Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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?

12 Replies
sunny_talwar

What is the definition of vArea_Top_1 variable?

swuehl
MVP
MVP

Is this

$(vArea_Top_1)


using an expression that is influenced by user selections?

Chanty4u
MVP
MVP

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

samuel_brierley
Creator
Creator
Author

it results in 'Junction 6A M1, M25' which is set in the load script by this

let vArea_Top_1 = peek('Area',0, 'Top Area');

Chanty4u
MVP
MVP

or else

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

sunny_talwar

Selection in which field is causing this issue for you?

Chanty4u
MVP
MVP

try this

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

samuel_brierley
Creator
Creator
Author

no ive checked that by using a text box purely with the variable and madew slection. the value didint change

samuel_brierley
Creator
Creator
Author

Hi Chanty,

unfortunately non of those work