topic Re: Current vs previous sales in QlikView

Current vs previous sales

geogou1973 — Sun, 10 Nov 2013 07:31:04 GMT

Hello.

I'm looking for days a formula with set analysis, when i select the day of the current year to show me in a chart the current selected day sales and the previous day sales (-364 days)
For example if i select 23/10/2013 to shows me the sales for 23/10/2013 and the sales for 24/10/2012.

I can't find anything. Can someone help me with this problem?

I have an attach file below.

Thank you in advance.

Re: Current vs previous sales

mdmukramali — Sun, 10 Nov 2013 08:05:03 GMT

Dear,

Kindly find the attachment.

Thanks,

Mukram.

Re: Current vs previous sales

rustyfishbones — Sun, 10 Nov 2013 10:12:07 GMT

Try

Sum({< DATE = {'$(=DATE(Today()))', '$(=DATE(AddYears(Today(), -1)))'} >} SALES)

Re: Current vs previous sales

geogou1973 — Sun, 10 Nov 2013 11:23:48 GMT

Thank you very much.

It was so simple with the variable.

Re: Current vs previous sales

geogou1973 — Sun, 10 Nov 2013 14:37:25 GMT

Dear Mohammed i try to apply this formula to compare the current and the previous sales by giving the year and the month but i don't have a result for the previous.

I create a variable for the previous year vPreviousYear=max(YEAR)-1

and in set analysis i write the following:

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

What i do wrong.

Can you help me ?