topic problem in comparative analysis in QlikView https://community.qlik.com/t5/QlikView/problem-in-comparative-analysis/m-p/424672#M158179 <HTML><HEAD></HEAD><BODY><P>Dear </P><P>I got an expression which calculates the total sales: sum({&lt;Flag='Sales'&gt;}AmountInUSD)</P><P>I got a pivot table that groups the sales by country and I'm getting correct results</P><P></P><P>Now I'm using the same expression as follows in comparative analysis scenario</P><P>Sum({[CurrentYear]&lt;Flag={'Sales'}, Brand= $::Brand&gt;}AmountInUSD)</P><P></P><P>now the amounts become less than the original , knowing that sales records may have the Brand as null</P><P></P><P>Please advise on how to force qlikview to include the records with null brands in comparative analysis</P></BODY></HTML> Thu, 20 Sep 2012 07:04:18 GMT ali_hijazi 2012-09-20T07:04:18Z problem in comparative analysis https://community.qlik.com/t5/QlikView/problem-in-comparative-analysis/m-p/424672#M158179 <HTML><HEAD></HEAD><BODY><P>Dear </P><P>I got an expression which calculates the total sales: sum({&lt;Flag='Sales'&gt;}AmountInUSD)</P><P>I got a pivot table that groups the sales by country and I'm getting correct results</P><P></P><P>Now I'm using the same expression as follows in comparative analysis scenario</P><P>Sum({[CurrentYear]&lt;Flag={'Sales'}, Brand= $::Brand&gt;}AmountInUSD)</P><P></P><P>now the amounts become less than the original , knowing that sales records may have the Brand as null</P><P></P><P>Please advise on how to force qlikview to include the records with null brands in comparative analysis</P></BODY></HTML> Thu, 20 Sep 2012 07:04:18 GMT https://community.qlik.com/t5/QlikView/problem-in-comparative-analysis/m-p/424672#M158179 ali_hijazi 2012-09-20T07:04:18Z Re: problem in comparative analysis https://community.qlik.com/t5/QlikView/problem-in-comparative-analysis/m-p/424673#M158180 <HTML><HEAD></HEAD><BODY><P>You could change the null values for brand in the script, to something like "No Brand"</P></BODY></HTML> Tue, 11 Dec 2012 09:22:31 GMT https://community.qlik.com/t5/QlikView/problem-in-comparative-analysis/m-p/424673#M158180 calvindk 2012-12-11T09:22:31Z