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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis: comparison vs last year, simple example

Hello,

It should be very easy, nevertheless I can't get this working. I simply would like to display the correct value in Quarter - 1....

Can anybody see my set analysis ?

I've attached the qlikview file...

Thank you for your help!

Labels (1)
1 Reply
Not applicable
Author

I am not clear on what your exact requirements are but : -

=sum({1<[Quarter number]={$(=Only([Quarter number])-1)}>} ZE_value)

Will give you Q1 if you have Q2 selected