Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

geogou1973
New Contributor II

compare sales current vs previous

Hello.

I have a database that has the sales of the stores by hour every day for the years 2012 and 2013.

How can i have in a chart a current sale date or a period with the previous sale date in the same weekday with set analysis.

For example i have the sales of the date 23/10/2013 which is wednesday how can i bring in a chart the sales of 24/10/2012   

which is also wednesday. Also how can i compare the month and the week and the year to date in a chart by selection.

Thank you in advance.

3 Replies
MarcoARaymundo
Contributor III

Re: compare sales current vs previous

Try this

Atual state => Sum(Sales)

Previous state => Sum({<Year={'$(=(Year - 1))'}>} Sales)

geogou1973
New Contributor II

Re: compare sales current vs previous

Marco i want by selecting the 23/10/2013 automatically to bring me the 24/10/2012 and the sales of that day in a chart.

I don't know if i can convert the date to 20131023 and 201201024 and subtract 345 days and compare the weekdays.

But what can i do when the selection is the month or the week.

Is any set analysis that automatically give me the result of the previous sales by selecting only the current date or the month or the month and the week ?

MarcoARaymundo
Contributor III

Re: compare sales current vs previous

Ok!

Use the AddYears(DATE, -1)

Previous state => Sum({<DATE={'$(=AddYears(DATE, - 1))'}>} Sales)


If you attach a sample file, I can better understand what you need.

Community Browser