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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis and Alternate State

Dear Community Experts,

I am facing an issue with Set Analysis and Alternate State using a Variable.

Same Expression is working fine with out any Alternate State but not working in Alternate Statement.(Different Variable created)

=sum({<[Field1]={"abcd"},[Q & Y Name]={"$(VCurrentQtr)"},Month=,Year=>} [Amount])

Please help.

2 Replies
sunny_talwar
MVP
MVP

Where is the alternate state here? Can you may be share a sample to show what is not working?

Not applicable
Author

Thanks Sunny for the reply I have fixed it, but I have one more issue. I am using expression like below and it is giving right result for selected period.

Sum(if(Aggr(Avg(TOTAL <[Field1]> [ Rollups)])>'12', [Field1]),1,0))

But I want rolling 6 periods on line chart and when I am trying to use set Analysis it is not working.

Please help.

Thanks in advance.