One year Sales calculation

qlikviewwizard — Wed, 30 Sep 2015 08:57:49 GMT

Hi All,

I want to show the data for Sales from today to last year(today-365).

Sales should consider Sales for each Trans_ID where Flag='Y'.

For example:

First Transaction_Date for Trans_ID=1242 is 01/Jan/2014.

But I need to consider only from 30/Sep/2014 to 30/Sep/2015 as I am running today.Remaining Sales should be excluded.

Expression:

Sum({<Flag={'Y'},Year=, Quarter=, Month=,Transaction_Date={'>=$(=vStartDate)<=$(=vMaxDate)'}>} Sales)

vStartDate=date(today()-365,'MM/DD/YYYY')

vMaxDate=date(today(),'MM/DD/YYYY')

But it is not working. Please help me. Thanks in advance.

Re: One year Sales calculation

tresB — Wed, 30 Sep 2015 09:04:08 GMT

Change both the variables date formats to 'DD/MM/YYYY', like

=date(today(),'DD/MM/YYYY')

=date(today()-365,'DD/MM/YYYY')