Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could change the null values for brand in the script, to something like "No Brand"
You could change the null values for brand in the script, to something like "No Brand"