problem in comparative analysis

[ali_hijazi]

Dear

I got an expression which calculates the total sales: sum({<Flag='Sales'>}AmountInUSD)

I got a pivot table that groups the sales by country and I'm getting correct results

Now I'm using the same expression as follows in comparative analysis scenario

Sum({[CurrentYear]<Flag={'Sales'}, Brand= $::Brand>}AmountInUSD)

now the amounts become less than the original , knowing that sales records may have the Brand as null

Please advise on how to force qlikview to include the records with null brands in comparative analysis

[calvindk · Accepted solution]

You could change the null values for brand in the script, to something like "No Brand"