Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
evansabres
Specialist
Specialist

Previous Day Sales

I have a field, transDATE, representative of the transaction date. I have a field [Net Sold Qty] representative of the number of tickets sold.

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.

Would I set this up in the script or in an expression? What would this look like?

0 Replies