Limiting Dashboard Rows.

[rajarshi_guin]

Hi All,

I have a dashboard which has one dimension and three measures.

Firm

Open Cases

Closed Cases

Reassigned Cases

Here Firm is a dimension while the others are measures. Now in this dashboard I need to show the rows only for the Firms where Open Cases and Closed Cases both are greater than 0 irrespective of the value in Reassigned Cases column. If for a firm Open Cases=0 and Closed Cases=0, the row for that Firm will not be displayed even if Reassigned Cases>0.

How can this be achieved in Qlik Sense?

Thanks,

Rajarshi Guin

[rittermd]

If you don't need to see all of the data in the app you could filter out the firms with Open and Closed cases = 0 in your script and then the only data in your app would be firms that have cases and you can just display them all.

[rajarshi_guin]

Hi Mark,

Those columns are calculated in runtime based on the dates the user selects as filters. So, they cannot be removed in the script.

[OmarBenSalem]

Maybe as expressions:

Expression 1 : expression for  Open Cases

Expression 2 : expression for closed cases

Expression 3, if(expression for open cases=0 and expression for closed cases =0, 0, expression for reassigned cases

and then, under, adds-on, uncheck: show zero values:

[agigliotti]

you can use the below in your chart object:

dimension:

Aggr( if( Count( Open_Cases ) > 0 and Count( Closed_Cases) > 0, Firm, null() ), Firm)

and untick "Include null values".

[rajarshi_guin]

Hi Omar,

This has solved the issue. Thanks.