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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Displaying missing values when comparing last year

Hi All

I have a scenario , where i have to display the missing values of the current year when compared to last year.. How to find it

Thanks


2 Replies
MayilVahanan

Hi

Are you need to find the difference between current year and last year?

Hope expression 1 contains current year and expression 2 contains last year.

If so, then try like this

= Column(1) - Column(2)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

A scenario where 2014 has 50 Values and 2013 has 25 values.I want to display the values which are missing