topic Re: How to Get the Year Wise Comparisons In Charts in QlikView

How to Get the Year Wise Comparisons In Charts

Mon, 24 Sep 2012 14:27:56 GMT

Hi Community Members,

I want to compare the sum (sales) with previous Year in chart, i.e when I select a 2006,it should be display chart with 2007 and 2006 years data in a chart.Thanks in advance.

Regards

Rams

Re: How to Get the Year Wise Comparisons In Charts

christophebrault — Mon, 24 Sep 2012 14:35:15 GMT

Hi,

set month as a dimension and then 2 expressions :

sum({$<Year={$(=Max(Year))}>}Sales) // the year selected

sum({$<Year={$(=Max(Year)-1)}>}Sales)// Past Year

Re: How to Get the Year Wise Comparisons In Charts

Mon, 24 Sep 2012 16:18:07 GMT

Thanks christopher ,I got in bar charts ,but I am unable to get it in Guage charts.Can you help me please

Regard

rams