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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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.