Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
rank_nandha
Contributor II

Cascading Filter


Hi,

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

Regards,

Nandha

1 Solution

Accepted Solutions
rank_nandha
Contributor II

Re: Cascading Filter

Hi All,

This is fixed when I add expression {1} before my set analysis. For eg., =Count ({1}column_name)

Also we want to wirte an expression in Expression attribute as like below

=if (column_name=column_name, color(FieldIndex('Name',column_name)),LightGray())

If I do this the chart is not showing the default colors. It getting the colors by its own.

Can any one help me here?

Regards,

Nandha

12 Replies
danieloberbilli
Valued Contributor II

Re: Cascading Filter

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   

rank_nandha
Contributor II

Re: Cascading Filter

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
Valued Contributor II

Re: Cascading Filter

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

rank_nandha
Contributor II

Re: Cascading Filter

Is there any sample file for this?

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

Regards,

Nandha

MVP & Luminary
MVP & Luminary

Re: Cascading Filter

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
Valued Contributor II

Re: Cascading Filter

PFA  an example

danieloberbilli
Valued Contributor II

Re: Cascading Filter

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

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

    ,LightGreen(),White()))

rank_nandha
Contributor II

Re: Cascading Filter

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

MVP & Luminary
MVP & Luminary

Re: Cascading Filter

Hi Nandha,

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

Regards,

Jagan.