topic Re: Previous Day Sales in QlikView

Previous Day Sales

wassimharfoush — Mon, 18 Aug 2014 17:02:37 GMT

I am trying to get previous day sales. I tried this expression but did not work:

=Sum({$<DatField={'$(VarPreviousDay)'}>}SalesField)

The variable set as follow:

VarPreviousDay=Date(Today()-1,'MM/DD/YYYY')

Re: Previous Day Sales

Gysbert_Wassenaar — Mon, 18 Aug 2014 17:19:11 GMT

That should work if you use the same date format that DatField has, but only if you don't use DatField as dimension in your chart. A set analysis expression calculates one set per chart, not a set per row.

Re: Previous Day Sales

aveeeeeee7en — Mon, 18 Aug 2014 17:36:59 GMT

Hi wassim

First check that both formats are same or not.

You have made your variable date in 'MM/DD/YYYY' format.

Please check that your DatField is in the 'MM/DD/YYYY' format ir not.

If not than try changing it.

If Yes, than use this expression:

=Sum({$<DatField={'$(=(VarPreviousDay))'}>}SalesField)

Also, see the Attachment.

Regards

Aviral Nag

Re: Previous Day Sales

wassimharfoush — Mon, 18 Aug 2014 17:47:14 GMT

The date format is the same format as the variable. And is not working for me any other suggestions?

Re: Previous Day Sales

Gysbert_Wassenaar — Mon, 18 Aug 2014 17:54:42 GMT

Post an example document that demonstrates the problem.

Re: Previous Day Sales

muniyandi — Mon, 18 Aug 2014 18:20:28 GMT

Hi Wassim,

your variable front of put equal.

try this expression.

Sum({$<DatField={'$(=VarPreviousDay)'}>}SalesField)

variable front of put equal.

Thanks,

Muni