topic Previous Day Sales in QlikView https://community.qlik.com/t5/QlikView/Previous-Day-Sales/m-p/71312#M11713 <HTML><HEAD></HEAD><BODY><P>I have a field, transDATE, representative of the transaction date. I have a field [Net Sold Qty] representative of the number of tickets sold.</P><P></P><P>I want to create a column within a table that shows the previous day sales. So if today, I have 10,000 tickets sold, but yesterday, I had 9,900 tickets sold, i want to be able to show that there were 100 tickets sold.</P><P></P><P>Would I set this up in the script or in an expression? What would this look</P></BODY></HTML> Tue, 22 May 2018 13:41:18 GMT evansabres 2018-05-22T13:41:18Z Previous Day Sales https://community.qlik.com/t5/QlikView/Previous-Day-Sales/m-p/71312#M11713 <HTML><HEAD></HEAD><BODY><P>I have a field, transDATE, representative of the transaction date. I have a field [Net Sold Qty] representative of the number of tickets sold.</P><P></P><P>I want to create a column within a table that shows the previous day sales. So if today, I have 10,000 tickets sold, but yesterday, I had 9,900 tickets sold, i want to be able to show that there were 100 tickets sold.</P><P></P><P>Would I set this up in the script or in an expression? What would this look</P></BODY></HTML> Tue, 22 May 2018 13:41:18 GMT https://community.qlik.com/t5/QlikView/Previous-Day-Sales/m-p/71312#M11713 evansabres 2018-05-22T13:41:18Z Re: Previous Day Sales https://community.qlik.com/t5/QlikView/Previous-Day-Sales/m-p/71313#M11714 <HTML><HEAD></HEAD><BODY><P>Did you try previous function like this -</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">previous(transDATE)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Use this in the main script<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P>Thank you!</P></BODY></HTML> Tue, 22 May 2018 13:55:51 GMT https://community.qlik.com/t5/QlikView/Previous-Day-Sales/m-p/71313#M11714 isingh30 2018-05-22T13:55:51Z Re: Previous Day Sales https://community.qlik.com/t5/QlikView/Previous-Day-Sales/m-p/71314#M11715 <HTML><HEAD></HEAD><BODY><P>I think I actually found my answer</P><P>=sum({&lt;transDATE={'$(=Date(max(transDATE,2)))'}&gt;} [Net Sold Qty])</P></BODY></HTML> Tue, 22 May 2018 13:57:48 GMT https://community.qlik.com/t5/QlikView/Previous-Day-Sales/m-p/71314#M11715 evansabres 2018-05-22T13:57:48Z