Cascading Filter

[Anonymous]

Hi,

Can any one explain me with an example can we do cascading filters in Qlikview?

Regards,

Nandha

[danieloberbilli]

If you select sth in one Listbox, other Listboxes will show which (further) values are possible to select (white) or not (grey) according to your datamodel.

You could setup something like showing certain listboxes only if a certain selection in a (previous) listbox was done by the user - to create a certain funnel/workflow.

E.g.

1) Listbox FieldA    - user selects one value

2) Listbox FieldB    - Conditional show in object property tab Layout: getselectedcount(FieldA)=1   

[Anonymous]

Hi Daniel,

Thanks for the swift reply.

This is for filter or list box. But my client asking for the below

This has to be appear in the graphs of the dashabord. For example I have Bar Chart and Pie Chart in a dashboard. If I select one bar in the bar chart other bars should fadeout and the corresponding slice of pie should be shown in the pie chart. I want the same funda in viseversa.

Regards,

Nandha

[danieloberbilli]

Hi Nandha,

I dont know about Qlik Sense - but in QlikView it could be possible in some cases but might be a bit tricky.

E.g. the basic QV logic is: if you select something - it filters the datamodel in the background - so its not simply showing/not showing bars - its actually filtering out. If you click on a piece of  pie chart showing 15% - it will most probably show 100% afterwards as you filtered on these particular cases.

Once I read here somewhere about a clever approach where you actually use a listbox to highlight certain bars. The idea was that you have a background color condition: e.g.  you click on listbox value 'March 2015'  and then the backgroundcolor of all the other bars turn white (invisible) or grey and the particular bar is shown in bright green...that might be a way to solve this without overcomplicating the expressions/dimensions in your chart.

Kind Regards

Daniel

[Anonymous]

Is there any sample file for this?

or Can you please send me the link where this is explained?

Regards,

Nandha

[jagan]

HI,

You can try this by using the Background Color of the Expression, use GetFieldSelections() to get the selected values and give different background color for the remaining bars which are not selected conditionally.

Or you can use the Set Reference option which comes with the default qlikview app.

Right click on the chart and click on Set Reference option, now whatever the values you selected it will be shown other values are fadeout.

Check below urls

Set Reference & Clear reference in Bar chart,line & combo

youtube.com/watch?v=PcDMfhpLmQM

Hope this helps you.

Regards,

Jagan.

[danieloberbilli]

PFA  an example

[danieloberbilli]

if(GetSelectedCount(HighLight)=0,LightBlue(),

if(GetSelectedCount(HighLight)>0 and WildMatch(Dim1, HighLight)

    ,LightGreen(),White()))

[Anonymous]

Hi Jagan,

Thanks for your reply.

I got this Set Reference funda from community. This help me to solve problem for the bar chart but its not solving the pie chart.

If i click a slice of pie its showing 100% not the slice value.

Regards,

Nandha

[jagan]

Hi Nandha,

Set Reference is not available for Pie chart, you can try Daniel Oberbillig suggestion for this.

Regards,

Jagan.