Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Mt3
Contributor III
Contributor III

Substract choices from alternate state from original set

Hi,

Has anybody tried to substract choices from alternate state from data set original set?

Lets assume we have a filter field called Value, on which we have assigned AlternateState1. I would like to show values remaining in the value set after user choses Values assigned to AlternateState1:

count(Value)-count({[AlternateState1]}Value)

However, when I visualize results in a new table (alternate state:default) , amount is not being substracted at all.

Would be grateful for any suggestions where to look next, as apparently this alternate state identifier in the set expression is not working properly.

 

 

2 Replies
anat
Master
Master

count(all Value)-count({[AlternateState1]}Value)

Mt3
Contributor III
Contributor III
Author

Thank you for the response, the result does not change either. I have also tried 

COUNT({1 - AlternateState1} [VALUE])

But the new table does not reflect results at all - when I chose a Value in AlternateState1, values in tables remain unchanged. Could it be some issue with Alternate States itself?  I have assigned them to filters by Apperance - > State-> AlternateState1.