iviasensio / SheetEvents

Add guided to your apps triggering actions when open a sheet
3 stars 8 forks source link

Sheet Events #3

Open andremedeiros86 opened 4 years ago

andremedeiros86 commented 4 years ago

Hi, i'm a qlik developer. i install the sheetEvents and configure to when i open the sheet, charge the year and month, but if already have the year and month selected, it is not to filter. how to do that?

iviasensio commented 4 years ago

Hi Andre, I've just test it again with Nov'19 and it works. If I make some selections in a sheet where I've palced Sheet Events and then I access again to that sheet the new filters are correctly applyed. That's because previous to filter there is a trigger that clear the current selections. I just include a delay to action of 500 milisecons, and write the fields without any tag =', like you can see in the image
image

andremedeiros86 commented 4 years ago

I don't think I could explain to you what I'm trying to do. If I am in a folder, with a Year and Month filter, and enter another folder that has the SheetEvent, it redoes the existing filter with what is informed in the SheetEvents. What I want is that if there is already a filter done, when entering the folder with SheetEvents, it does not delete the existing filter.

Em ter., 28 de jan. de 2020 às 11:39, Ivan Felipe Asensio < notifications@github.com> escreveu:

Hi Andre, I've just test it again with Nov'19 and it works. If I make some selections in a sheet where I've palced Sheet Events and then I access again to that sheet the new filters are correctly applyed. That's because previous to filter there is a trigger that clear the current selections. I just include a delay to action of 500 milisecons, and write the fields without any tag =', like you can see in the image [image: image] https://user-images.githubusercontent.com/11334576/73273455-4ab5d180-41e4-11ea-8acd-fadbf6bac20f.png

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/iviasensio/SheetEvents/issues/3?email_source=notifications&email_token=AOMYS36EPTGGTOIMMFNXYI3RAA7Q3A5CNFSM4KMTHWHKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEKDQ5GY#issuecomment-579276443, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOMYS327K7UVLENVSSKGK3DRAA7Q3ANCNFSM4KMTHWHA .

-- André Augusto Tavares de Medeiros

andremedeiros86 commented 4 years ago

In others versions of QlikSense, I used this expression. But this stop work if i'm with filters. [image: image.png]

Em ter., 28 de jan. de 2020 às 13:09, André Medeiros < andre.medeiros86@gmail.com> escreveu:

I don't think I could explain to you what I'm trying to do. If I am in a folder, with a Year and Month filter, and enter another folder that has the SheetEvent, it redoes the existing filter with what is informed in the SheetEvents. What I want is that if there is already a filter done, when entering the folder with SheetEvents, it does not delete the existing filter.

Em ter., 28 de jan. de 2020 às 11:39, Ivan Felipe Asensio < notifications@github.com> escreveu:

Hi Andre, I've just test it again with Nov'19 and it works. If I make some selections in a sheet where I've palced Sheet Events and then I access again to that sheet the new filters are correctly applyed. That's because previous to filter there is a trigger that clear the current selections. I just include a delay to action of 500 milisecons, and write the fields without any tag =', like you can see in the image [image: image] https://user-images.githubusercontent.com/11334576/73273455-4ab5d180-41e4-11ea-8acd-fadbf6bac20f.png

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/iviasensio/SheetEvents/issues/3?email_source=notifications&email_token=AOMYS36EPTGGTOIMMFNXYI3RAA7Q3A5CNFSM4KMTHWHKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEKDQ5GY#issuecomment-579276443, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOMYS327K7UVLENVSSKGK3DRAA7Q3ANCNFSM4KMTHWHA .

-- André Augusto Tavares de Medeiros

-- André Augusto Tavares de Medeiros

andremedeiros86 commented 4 years ago

Solved.

Now, don't need the '''&$(getfiieldselections(Ano))&''', only GetFieldSelections(Ano).

Thanks.

Em ter., 28 de jan. de 2020 às 13:22, André Medeiros < andre.medeiros86@gmail.com> escreveu:

In others versions of QlikSense, I used this expression. But this stop work if i'm with filters. [image: image.png]

Em ter., 28 de jan. de 2020 às 13:09, André Medeiros < andre.medeiros86@gmail.com> escreveu:

I don't think I could explain to you what I'm trying to do. If I am in a folder, with a Year and Month filter, and enter another folder that has the SheetEvent, it redoes the existing filter with what is informed in the SheetEvents. What I want is that if there is already a filter done, when entering the folder with SheetEvents, it does not delete the existing filter.

Em ter., 28 de jan. de 2020 às 11:39, Ivan Felipe Asensio < notifications@github.com> escreveu:

Hi Andre, I've just test it again with Nov'19 and it works. If I make some selections in a sheet where I've palced Sheet Events and then I access again to that sheet the new filters are correctly applyed. That's because previous to filter there is a trigger that clear the current selections. I just include a delay to action of 500 milisecons, and write the fields without any tag =', like you can see in the image [image: image] https://user-images.githubusercontent.com/11334576/73273455-4ab5d180-41e4-11ea-8acd-fadbf6bac20f.png

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/iviasensio/SheetEvents/issues/3?email_source=notifications&email_token=AOMYS36EPTGGTOIMMFNXYI3RAA7Q3A5CNFSM4KMTHWHKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEKDQ5GY#issuecomment-579276443, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOMYS327K7UVLENVSSKGK3DRAA7Q3ANCNFSM4KMTHWHA .

-- André Augusto Tavares de Medeiros

-- André Augusto Tavares de Medeiros

-- André Augusto Tavares de Medeiros