Skip to main content
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!

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