Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
show spaces when values are null in qlikview
pfa file
In the chart, Sales bar should show P1,P2,P3 even though P2 is null
john
Something like this?
Expression: =If(Sum({$<Customer ={'A'}>}sales) = 0, 1, Sum({$<Customer ={'A'}>}sales))
Something like this?
Expression: =If(Sum({$<Customer ={'A'}>}sales) = 0, 1, Sum({$<Customer ={'A'}>}sales))
Thnx Sunny, this is what I needed.