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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_brierley
Creator
Creator

simple set analysis confusion

hi all,

it was my understanding that using a 1 in set analysis will ignore any current selections i.e clicking on charts and what not will not affect the chart with the 1.

i have the below expression in 3 different charts (the variable represents 1,2,3) however when i click on one chart the other 2 show 'No Date to Display'

sum({1< Area = {'$(vArea_Top_1)'}>} Lane_1_Total)

the dimension is Area btw.

can someone explain where i'm going wrong?

Labels (1)
12 Replies
swuehl
Champion III
Champion III

Any other expressions used in that chart (maybe within a attribute / conditional?)?

Could you upload a small sample QVW that demonstrates the issue?

samuel_brierley
Creator
Creator
Author

not that i can see.

ive attached the QVD, the charts in question are the 3 bar charts at the top right.

thanks swuehl.

p.s im not on a licensed machine so if you dont mind please try and explain the solution

swuehl
Champion III
Champion III

You are indeed using aggregations without that set identifier, you need to ignore selections in every aggregation, like

=sum({1< Area = {'$(vArea_Top_2)'}>} Lane_1_Total)/count( {1} distinct(Time))*6