Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

How to de select Value using Trigger

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

 

 

Labels (1)
2 Replies
zhadrakas
Specialist II
Specialist II

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

Hi 

 

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