Eliminating specific rows in dashboard

[rajarshi_guin]

Hi All,

I have a dashboard in the below format.

Firm	Cases Closed	Cases Created	In-Progress Cases
A	10	0	0
B	0	0	0
C	0	20	0

The column Firm is a dimension while others are measures.

Now the requirement is to show only the firms for which atleast one of the measure is a non-zero value, i.e., the firms for which all the measures are 0 will not be displayed in the dashboard.

So, in this case in the output I should have only the below two rows and not the row for firm B as fro firm B all the measures are 0.

Firm	Cases Closed	Cases Created	In-Progress Cases
A	10	0	0
C	0	20	0

Can anyone please let me know how to implement this in Qlik Sense.

Thanks,

Rajarshi Guin

[sunny_talwar]

May be remove them while loading like this

LOAD ...

FROM ...

Where RangeSum([Cases Closed], [Cases Created], [In-Progress Cases]) > 0;

[rajarshi_guin]

Hi Sunny,

The measures are calculated based on filters which the users will select while running the dashboard. So, I think this cannot be done while loading.

[sunny_talwar]

Are you using a pivot table where cases closed, cases created, etc are part of a pivoted dimension?

[shivanandk]

If you are using a straight table there is option to suppress zero values