Solved: Yesterday Sales - Qlik Community - 1797449

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

Dear Community

I have the following set analysis:

=Max({<$(vMeasure)={<>},Date={<>}>}Date)

I need to go back one day only from this point. I have tried the minus one but I am failing to have success

Can you help

Regards

1 Solution

Accepted Solutions

Try like below

=Date(Max(Date)-1, 'YourDateFormat')

or

=Date(Today()-1, 'YourDateFormat'))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply

Try like below

=Date(Max(Date)-1, 'YourDateFormat')

or

=Date(Today()-1, 'YourDateFormat'))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.