I am working on a Qlikview application where in I am stuck with a requirement which I am not sure if possible or not.
My probelm statement goes like this -
I have filters/listboxes on the LHS of the dashboard. there are around 10 filters of which we have categorized them as gray colored filters and blue colored filters by coloring them. the blue colored filters will apply only 2 charts in the dashboard and the gray filters will work on the entire dashboard. The data source for this dashboard is a single table.
By default i am aware that qlik filters are associative. But i want the blue filters to not affect the gray filters when something is selected in the blue filters. We can do this in charts by using set analysis but how do i achieve this with filters?
My requirement or concentration is mainly on the Filters. I want the grey filters to affect the blue colored filters but not the vice versa. That means,if i select something in the grey filters, the possible selections in the blue filters will be shown which is the basic functions in qlikview. Bur if i select something in the blue filters the grey filters should not be affected by the choice in blue filters. No values should be filtered out in the grey filters. How can i do this?
Using alternate states will make the two sections of filters to be detached , the associative property will be lost. I need the associative property to be unidirectional(top - down approach) instead of bidirectional.
Can anyone help me to achieve this? or can anyone tell me is this possible?