topic Only Show active records in dashboard in QlikView

Only Show active records in dashboard

sujit_nath — Mon, 11 Jun 2018 14:27:43 GMT

Hi,

I need a use case as:

I have several list boxes, one of them being "Result"

I want that result list box to be configured in such a way that: If I select other fields, only data corresponding to those should be present in "Result". Otherwise it should show blank.

As the usual behavior of qlikview marks the inactive values as grey, I want them to be hidden completely.

Thanks in advance!!

Re: Only Show active records in dashboard

ogautier62 — Mon, 11 Jun 2018 14:42:18 GMT

Hi,

rather than list selection box, use table object with field result

so : no grey value

to have blank if no selection made,

then in 'calcul conditions' write : len(getcurrentselection)>0

and in error message put blanks

regards

Re: Only Show active records in dashboard

isingh30 — Mon, 11 Jun 2018 15:02:11 GMT

Just check in Hide Excluded.