Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Mt3
Contributor III
Contributor III
‎2022-01-26 06:56 AM

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.

 

 

396 Views
0 Likes
2 Replies
anat
Master
Master
‎2022-01-26 07:20 AM

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

362 Views
0 Likes
Mt3
Contributor III
Contributor III
‎2022-01-26 07:36 AM
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.

335 Views
0 Likes