Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude an Alternate State group

Hi all,

I have an object which I do not want it to be affected by a trigger. And the only way I found was by manipulating the expression, something like:

=If(GetSelectedCount(ID)>0, Concat(DISTINCT EmployeeID, ', '), '')

Is is possible to add the alternate state group in it but by excluding it.

All I could find was how to include it, example:

=If(GetSelectedCount(ID)>0, Concat( {AlternateStateA} DISTINCT EmployeeID, ', '), '')

Is it possible to exclude the state?

Thanks,

4 Replies
sunny_talwar

What about this?

=If(GetSelectedCount(ID)>0, Concat({$} DISTINCT EmployeeID, ', '), '')

Not applicable
Author

I will give it a try, dont know if it will work for that particular solution...thank you.

Not applicable
Author

As I thought... the object (table chart) will still being affected by that selection. Thats why I thought of the alternate states. 

sunny_talwar

I am not sure what you are trying to do. Would you be able to elaborate a little more?