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: 
Not applicable

set analysis for previous day

Hi,

the set analysis expression for the selected date in my chart is Sum({$<Date=P({$} tDate )>} Sales) , its working fine, I want another column with previous date to compare the sales.

Thanks in Advance...

1 Solution

Accepted Solutions
deepakk
Partner - Specialist III
Partner - Specialist III

hi,

Create DateNum field at script level.

eg: Num(Date) as DateNum,

and Use the below expression

Sum({<DateNum={$(=(Max(DateNum)-1))}>} Sales)

View solution in original post

2 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi,

Create DateNum field at script level.

eg: Num(Date) as DateNum,

and Use the below expression

Sum({<DateNum={$(=(Max(DateNum)-1))}>} Sales)

Not applicable
Author

Thanks