Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

How can I get my Set Analysis expression to pick up selections from any field in a Default State?

Hello all,

In a measure I have the following expression:

sum({StateA<Year=$::Year>}LineSalesAmount)

In this example I have got the expression to select anything from the Year field.

How can I get my chart to update based on multiple fields without having to specify it in the expression?

6 Replies
Gysbert_Wassenaar

Like this: sum({$}LineSalesAmount)


talk is cheap, supply exceeds demand
Anonymous
Not applicable

Which is the same as sum(LineSalesAmount)

Anonymous
Not applicable

Michael

.... unless the expression is within an object with an Alternate State set......

Anonymous
Not applicable

True, thanks Bill.

Gysbert_Wassenaar

Not necessarily. See this blog post: Set Analysis & Alternate States – Quick Tip » The Qlik Board!. Perhaps there should be a symbol for the inherited state too. That would allow one to always be explicit about which state should be used.


talk is cheap, supply exceeds demand
Anonymous
Not applicable

Yes, it would be helpful of course.