Hi,
In a pivot table there's a nice functionality which allows to display nulls and missing differently. Null is displayed as nulls, and missing is displayed as '-'. In my model a null budget and an absent budget are two differnet things. So, I'm using the functionality.
If I select some brands in the list-box and display them in a cross-table, nulls and missings are displayed correctly.
But there is an exception. There's a functionality in my application which allows to clear all current selections and display Top-10 brands in a pivot table by the means of a set expression.
sum({$<Brands={"=rank(sum({$<Brands=>} [Cost] ))<=10"}>}, Brands)
And then QlikView displays actual nulls and missings wrong.
Can you advise something to fix it?
Thank you in advance,
Larisa
