Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below sample table
Dim, Value
A, 1
A, -1
B, 2
C, 3
We are displaying this information in Qlik Sense UI Table with sum(Value) as a measure. Also we're supressing rows where sum(Value) comes as zero. So row with Dim as A would be supressed.
Now User also wants the count of rows which are being displayed in this table in sheet title. The correct result here, would be 2 .
If I derive this count using expression count(aggr(sum(Value), Dim)) it comes up as 3 since it counts the row with dim A.
How can I supress 0 measure row inside aggr or if there is any other possible solution to this requirement, let me know? I
Hi, maybe calculating this as: sum(aggr(If(sum(Value)<>0,1), Dim))
Hi, maybe calculating this as: sum(aggr(If(sum(Value)<>0,1), Dim))