Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik1_User1
Specialist
Specialist

using 1 in set analysis is not working

Hi All,

When I am using '1' in set analysis its not working as expect, means filter condition mentioned in set analysis is getting impacted.

Expression
Count(distinct{<status={'a'},T_year={'$(=year(today()))'}>} ID) --> 10 (correct)
Count(distinct{1<status={'a'},T_year={'$(=year(today()))'}>} ID) --> 100 (incorrect), expected O/P -->10

I want to make this expression static from selection except the filter condition mentioned in set analysis

Labels (5)
1 Reply
vinieme12
Champion III
Champion III

Even if the expression was responding to selections, it would not show a higher value 

because filtering is basically reducing the amount of data to be evaluated 

 

Can you please post a screenshot of the expression editor

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.