topic Re: Only Show active records in dashboard in QlikView

Only Show active records in dashboard

sujit_nath — Mon, 11 Jun 2018 14:16:32 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

m_woolf — Mon, 11 Jun 2018 15:29:45 GMT

Listbox|Properties|General|Hide Excluded

Re: Only Show active records in dashboard

MarcoWedel — Mon, 11 Jun 2018 20:22:53 GMT

Instead of selecting the field "Result" in your list box, try with an expression like

Aggr(Result,Result)

hope this helps

regards

Marco