Discussion board where members can get started with QlikView.
Hi, I want to show only values that have nulls on my straight table, how do I include this condition on an expression?
So e.g, in the example that I attached I want my table to return only Acc Num 223 and 200.
try caluclation dimension
If(Len(Trim([Field])) = 0, 'Null', Null())
you need to write your dimension as
If(Len(Trim(Ind)) = 0, [Acc Num])
Then check the suppress when value is null
Then add your expression
for example Sum(sales) or for testing add expression as 1
It will show values only for Acc Num 223 and 200.
Thank you all very much, it works perfectly 🙂
Nice Please close the thread by making correct and helpful