topic Re: Displaying missing values when comparing last year in QlikView https://community.qlik.com/t5/QlikView/Displaying-missing-values-when-comparing-last-year/m-p/638587#M543061 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Are you need to find the difference between current year and last year?</P><P></P><P>Hope expression 1 contains current year and expression 2 contains last year.</P><P></P><P>If so, then try like this</P><P>= Column(1) - Column(2)</P></BODY></HTML> Wed, 04 Jun 2014 05:43:58 GMT MayilVahanan 2014-06-04T05:43:58Z Displaying missing values when comparing last year https://community.qlik.com/t5/QlikView/Displaying-missing-values-when-comparing-last-year/m-p/638586#M543060 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>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</P><P></P><P></P><P>Thanks</P><P><BR /> </P></BODY></HTML> Wed, 04 Jun 2014 05:39:17 GMT https://community.qlik.com/t5/QlikView/Displaying-missing-values-when-comparing-last-year/m-p/638586#M543060 2014-06-04T05:39:17Z Re: Displaying missing values when comparing last year https://community.qlik.com/t5/QlikView/Displaying-missing-values-when-comparing-last-year/m-p/638587#M543061 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Are you need to find the difference between current year and last year?</P><P></P><P>Hope expression 1 contains current year and expression 2 contains last year.</P><P></P><P>If so, then try like this</P><P>= Column(1) - Column(2)</P></BODY></HTML> Wed, 04 Jun 2014 05:43:58 GMT https://community.qlik.com/t5/QlikView/Displaying-missing-values-when-comparing-last-year/m-p/638587#M543061 MayilVahanan 2014-06-04T05:43:58Z Re: Displaying missing values when comparing last year https://community.qlik.com/t5/QlikView/Displaying-missing-values-when-comparing-last-year/m-p/638588#M543062 <HTML><HEAD></HEAD><BODY><P>A scenario where 2014 has 50 Values and 2013 has 25 values.I want to display the values which are missing</P></BODY></HTML> Wed, 04 Jun 2014 05:47:43 GMT https://community.qlik.com/t5/QlikView/Displaying-missing-values-when-comparing-last-year/m-p/638588#M543062 2014-06-04T05:47:43Z