Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Any other expressions used in that chart (maybe within a attribute / conditional?)?
Could you upload a small sample QVW that demonstrates the issue?
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
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