Yr/Yr Bar Graph

Tue, 13 Apr 2010 15:07:25 GMT

Hello,

I built a bar graph that shows monthly sales against that same month last year. This works perfectly when I only have one rolling month selected in my list box. However, when I select two rolling months it displays the those two months and only last years data for one ( the greater) of the two selected months.

I am using this expression to get the previsous years data:

Sum({$<RollingMonth={"$(=Date(AddMonths(Max(RollingMonth),-12),'MM/YY'))"} >} Sales)

If I use Min instead of max, it simply displays the last years data for the lesser of the two month selected. Is there a way I can set this up where it will work correctly if one month is selected ( show sales totals for selected month and selected month-yr) and will also work correctly if two months are selected (shows sales totals for both months selected and corresponding months last year) .

Any Help would be appreciated.

Thanks Much!!

Yr/Yr Bar Graph

Tue, 13 Apr 2010 15:36:28 GMT

Hi, if the only thing you want to change is the year, if I understand correctly, you would only change the year within you set analysis expression.Your expression probably would look like this:

Sum({$<RollingYear={"$(=max(Year) - 1)"} >} Sales)

Hope this helps you

Regards

topic Yr/Yr Bar Graph in QlikView

Yr/Yr Bar Graph

Yr/Yr Bar Graph