topic Re: Filter value display in App Development

Filter value display

Mon, 07 Nov 2016 12:58:57 GMT

Hi,

I have two filters on an excel sheet. The filters are 'employee group' and 'employee name'. by default all the groups and all employee names are shown in the filters. When a employee group is selected, the related employee names are shown in white in the employee name filter, and, remaining are highlighted in black/grey.

Is there any way out where when I select a group, the name filter should show only the records related to the selected group??

Please help.

Thanks,

Rahul Krishan Goyal

Re: Filter value display

stigchel — Mon, 07 Nov 2016 13:12:05 GMT

Not sure about Sense, but in qlikview you can use an expression in a listbox instead of a field.

If you can do this in Sense then use an expression like

=Aggr(Only([employee name]),[employee name])

And the listbox will only display the possible 'white' values

Re: Filter value display

Mon, 07 Nov 2016 14:28:47 GMT

Hi Piet,

Thanks so much for your response.

Though, I am able to apply the function in Qlik sense also. But, in the list boc / filter drop down, no value is shown/showing blank list box.

Please help.

Rahul

Re: Filter value display

Mon, 07 Nov 2016 15:06:44 GMT

Hi Piet,

It has been resolved.

Thanks so much. I am so grateful to you.

Thank You,