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