Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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