topic Re: How to de select Value using Trigger in QlikView

How to de select Value using Trigger

mhmmd_srf — Sat, 16 Nov 2024 03:37:59 GMT

Hi All,

Hope you are doing good.

I have a requirement, Have 2 fields from 2 Table.

Category1 from Table1.

Category2 from Table2.

The requirement is when user selects any value from Category1, same values from Category2 also be selected and vice versa. I am able to implement this using Trigger function.

But User also want if he deselect any value from Category1, same value will be de selected from Category2. I am not able to do this.

Can anyone plz help me on this.

I am attaching the test file.

Thanks,

Sarif

Re: How to de select Value using Trigger

zhadrakas — Thu, 09 May 2019 09:08:50 GMT

This should work:
=if(GetSelectedCount(Category1)>0, '("' & Concat(DISTINCT Category1, '"|"') & '")')

Re: How to de select Value using Trigger

kushalthakral — Thu, 09 May 2019 11:00:41 GMT

You can write below expression in your triggers for both dimensions

in case of Category 1

=If(GetSelectedCount(Category1)>0,'("' & Concat(DISTINCT Category1, '"|"') & '")','')

In case of Category 2

=If(GetSelectedCount(Category2)>0,'("' & Concat(DISTINCT Category2, '"|"') & '")','')

i have checked this and it is working fine

Thanks

Kushal