topic i wanna create bar chart in QlikView

i wanna create bar chart

Fri, 19 Dec 2014 07:45:02 GMT

ž X-Axis -- Month (Past 13 Month)
ž Y-Axis - MoneySpend comparison for month over month (Comparing same month of last year with same month of current year)

please tell me how to achieve this

sushil353 — Fri, 19 Dec 2014 07:53:07 GMT

Hi,

For better solution..

you can post you sample data here...

for your solution. you can add month as dimension and in dimension list you can restrict them for latest 13 month.

and in expression you can create 2 expression..

sum({<Year = {'$(=Max(Year)-1)'}>}Sales) --- for previous year sales.

sum({<Year = {'$(=Max(Year))'}>}Sales) -- for current year sales.

HTH

sushil

Fri, 19 Dec 2014 07:56:56 GMT

Hi,

add month as dimension and > goto dimension limits > put latest 13> write above 2 expression what sushil provided