topic Re: Selector Ignore Another Selection in QlikView

Selector Ignore Another Selection

wonkymeister — Mon, 01 Oct 2018 13:26:41 GMT

I have a selector that I want to ignore the selection of another selector on a dashboard.

The dimension available to select: pay_grouping_types

The field in the other selector (which is always one selected) that I’d like to ignore: %month

I thought this would work but obviously doesn’t (result leaves no values available to select)

if(Only({$<%month=>} pay_grouping_types) <> 'Others', pay_grouping_types)

Any ideas guys?

sunny_talwar — Mon, 01 Oct 2018 13:42:14 GMT

May be try this

Aggr(Only({1<%month, pay_grouping_types = -{'Others'}>} pay_grouping_types), pay_grouping_types)

sunny_talwar — Mon, 01 Oct 2018 13:42:47 GMT

Or this

if(Only({$<%month=>} pay_grouping_types) <> 'Others', Only({$<%month=>} pay_grouping_types))

vitaliichupryna — Mon, 01 Oct 2018 13:51:05 GMT

Maybe I don't understand what you want, but if you want have independent selectors you can use alternate states

wonkymeister — Mon, 01 Oct 2018 13:59:46 GMT

still not working, still restricting on %month - i cant understand why though

sunny_talwar — Mon, 01 Oct 2018 14:11:41 GMT

Would you be a able to share a sample or sample image to show what you have?

wonkymeister — Mon, 01 Oct 2018 14:33:49 GMT

i cant i'm afraid - its restricted payroll data.

i think your examples should work fine - i think that maybe there is something else in the model interfering with this data.