topic Re: compare current vs previous sales in QlikView

compare current vs previous sales

geogou1973 — Fri, 25 Oct 2013 07:18:04 GMT

Hello.

How can i compare the current sales vs previous sales giving only the current year date in the selections and the chart giving me also the previous sale date in the same period and in the same weekday. Also if i give the month compare automatically the sales in the previous year. Is there any set analysis to do this ?

Thank you in advance.

Re: compare current vs previous sales

jagan — Fri, 25 Oct 2013 07:29:49 GMT

Hi,

Try like this

For Current Selections

=Sum(Sales)

For Previous Year

=Sum({<Year=, Month=, Quarter=,Week=,DateDimension={'>=$(=YearStart(Max(DateDimension), -1))<=$(=YearEnd(Max(Date), -1))'}>}Sales)

In the above expression replace DateDimension with your date field name, Year with Year field etc. Year= is used to ignore the selections.

Regards,

Jagan.

Re: compare current vs previous sales

Fri, 25 Oct 2013 07:35:58 GMT

for previous year

sum({<yearfield={"=$(=only(yearfiled)-1)"},quarterfiled=,monthfield={"=$(=max(monthfiled)-1)"}>}sales)

if month is in monthnames then use month number function.