topic Re: Applying default only to a specific element in a chart in QlikView

Applying default only to a specific element in a chart

Thu, 27 Mar 2014 03:32:30 GMT

Hello All,

I have got a sheet with a Line Graphs( 3 years of trend data) and a few Pie charts. I want my Pie chart to default to FY14 but the

line graph should show 3 trend lines. Please note there are other selection list boxes which can change both the line and Pie charts.

The problem I face is when I give a default I see a single trendline and Pies appear correct. I tried disassociating the file from the Line chart but then the functionality of the other list boxes is lost.

Appreciate any help or suggestion on this.

Vimal

Re: Applying default only to a specific element in a chart

Thu, 27 Mar 2014 03:35:42 GMT

Hi Govindan, You have to use set analysis in the expressions.

In your pie chart simply say Sum({<year_code={'FY14'}>}sales)

In your line chart say Sum({<year_code=,>} sales)

That should do the trick.

Thanks,

Ram

Re: Applying default only to a specific element in a chart

Anonymous — Thu, 27 Mar 2014 03:38:42 GMT

Can You provide a sample app,

it would be easy to understand the issue.

Anyway you can use different expression in pie chart with set analysis for

Year={FY2014}