topic Re: Linking charts with listboxes in QlikView

Linking charts with listboxes

Mon, 23 Feb 2015 12:39:17 GMT

Hi,

I have 4 dropdowns and 2 charts.

i want the 1st chart to be linked with all the 4 dropdowns which is happening now (default qlikview property). but the chalalnge is that i want the 2nd chart to be linked only with 3rd and 4th listboxes. if i use alternate states then it will break linking of the 1st chart.

hope i was clear enough.

Thnaks

Re: Linking charts with listboxes

yura_ratu — Mon, 23 Feb 2015 13:12:49 GMT

Hi Yousuf

You should use Set analysis for 2nd chart expressions. Like {<3rdField=,4thField=>} where 3rdField and 4thField are names of the fields from your listboxes

Re: Linking charts with listboxes

Mon, 23 Feb 2015 18:41:17 GMT

hi,

i tried that..but its still not reflecting.....i believe i am misssing something v minor. Can you please check the attachement. its one chart and it should not be linked to 1st listbox (quarter)

many thanks in advance.

Re: Linking charts with listboxes

Anonymous — Mon, 23 Feb 2015 19:08:15 GMT

if i understood your requirement correctly, then you were missing set analysis on some of your aggregation functions you used in your expression. take a look at the attachment and see if this is what you were hoping to accomplish.

Re: Linking charts with listboxes

Anonymous — Mon, 23 Feb 2015 19:13:38 GMT

and here is your original file. you need to use the set analysis to ignore the required fields in each of the aggregation function in each of your expression in the chart.

Re: Linking charts with listboxes

Mon, 23 Feb 2015 20:33:45 GMT

thanks a ton..