Only Show active records in dashboard

[sujit_nath]

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!!

[m_woolf]

Listbox|Properties|General|Hide Excluded

[MarcoWedel]

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

Aggr(Result,Result)

hope this helps

regards

Marco