topic Re: Making Pie chart for current and last year in QlikView

Making Pie chart for current and last year

Mon, 19 Nov 2012 09:59:34 GMT

Hello Friends,

I have to put a pie chart for current year and last year, in the dimention I have used the Mode of Transport and the meassure is weight.

Could you please help on this...

Regards

Chriss

Anonymous — Mon, 19 Nov 2012 10:06:58 GMT

Sum({$<Year={$(=Year(Today()))}>} Weight)

and

Sum({$<Year={$(=Year(Today())-1)}>} Weight)

Assuming that the expression is normally Sum(Weight)

jagan — Mon, 19 Nov 2012 10:14:16 GMT

Hi,

Try this

=Sum({<Year={'>=$(=(Max(Year) - 1))<=$(=Max(Year))'}>} Weight)

Hope this helps you.

Regards,

Jagan.

Mon, 19 Nov 2012 10:34:07 GMT

Thanks a lot both Johannes and Jean Mohan.. it works fine.

Regards

Chriss