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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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