topic Re: compare current vs previous sales by month in QlikView

compare current vs previous sales by month

geogou1973 — Sun, 10 Nov 2013 15:06:15 GMT

Hello.

How i can compare current vs previous sales by giving the current year in selection and the month

and return me in a chart the sales for the month of the current year and the month for the previous year.

I have created a variable for the previous year vPreviousYear=(Year)-1

and in the expression i give the following:

=Sum({<YEAR={'$(vPreviousYear)'},MONTH_ID=>}sales)

and returns me 0

Sun, 10 Nov 2013 15:47:00 GMT

Try Below:

=Sum({1<YEAR={"$(=Max(YEAR)-1)"},MONTH_ID=>}sales)

If you selected the YEAR value 2013, the data for 2012 was greyed out. SO you need to put {1} to ignore the current selections.

geogou1973 — Sun, 10 Nov 2013 16:11:59 GMT

It returns me wrong sales. Very big amounts.

Sun, 10 Nov 2013 16:34:03 GMT

Please post sample qvw or some test data.

Yousef_Amarneh — Sun, 10 Nov 2013 23:28:13 GMT

just go to the variable and but equal sign before the expression, so it should be =(Year)-1 instead of (Year)-1