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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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.