topic Re: Cascading Filter in QlikView

Cascading Filter

Anonymous — Tue, 07 Apr 2015 04:52:24 GMT

Hi,

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

Regards,

Nandha

Re: Cascading Filter

danieloberbilli — Tue, 07 Apr 2015 05:01:00 GMT

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

Re: Cascading Filter

Anonymous — Tue, 07 Apr 2015 05:06:14 GMT

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

Re: Cascading Filter

danieloberbilli — Tue, 07 Apr 2015 05:24:49 GMT

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

Re: Cascading Filter

Anonymous — Tue, 07 Apr 2015 05:28:40 GMT

Is there any sample file for this?

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

Regards,

Nandha

Re: Cascading Filter

jagan — Tue, 07 Apr 2015 05:29:25 GMT

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.

Re: Cascading Filter

danieloberbilli — Tue, 07 Apr 2015 05:31:55 GMT

PFA an example

Re: Cascading Filter

danieloberbilli — Tue, 07 Apr 2015 05:32:55 GMT

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

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

,LightGreen(),White()))

Re: Cascading Filter

Anonymous — Tue, 07 Apr 2015 06:33:14 GMT

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

Re: Cascading Filter

jagan — Tue, 07 Apr 2015 06:39:12 GMT

Hi Nandha,

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

Regards,

Jagan.

Re: Cascading Filter

Anonymous — Tue, 07 Apr 2015 10:22:55 GMT

Hi Jagan,

I am using the Brushing concept for the Pie. But I am facing problem in Bar chart.

After setting the "Set Reference" value the chart works fine. But this value disappear when we close and reopen the file.

Is there a solution to appear the Set Reference value permanently?

Regards,

Nandha

Re: Cascading Filter

jagan — Tue, 07 Apr 2015 10:28:39 GMT

No, this is not available.

Regards,

Jagan.

Re: Cascading Filter

Anonymous — Fri, 17 Apr 2015 06:51:35 GMT

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