Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Displaying missing values when comparing last year

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)

Not applicable

Re: Displaying missing values when comparing last year

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

Community Browser