topic Previous Day Sales in QlikView https://community.qlik.com/t5/QlikView/Previous-Day-Sales/m-p/71100#M11667 <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 like?</P></BODY></HTML> Tue, 22 May 2018 13:40:35 GMT evansabres 2018-05-22T13:40:35Z Previous Day Sales https://community.qlik.com/t5/QlikView/Previous-Day-Sales/m-p/71100#M11667 <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 like?</P></BODY></HTML> Tue, 22 May 2018 13:40:35 GMT https://community.qlik.com/t5/QlikView/Previous-Day-Sales/m-p/71100#M11667 evansabres 2018-05-22T13:40:35Z