Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to calculate the day before a certain date ?
So if date='2017/07/28' the calculated date should be '2017/07/27'
Hi Eric,
You can calculate using below set analysis:
Sum({<Date={'$(Max(Date)-1)'}>}value)
In Text Object=Date(Max(Today()-1))
Thanks,
Arvind Patil
Hi,
(Date - 1)??
Hi Eric,
You can calculate using below set analysis:
Sum({<Date={'$(Max(Date)-1)'}>}value)
In Text Object=Date(Max(Today()-1))
Thanks,
Arvind Patil
Thx,
thx
thx
Happy to Help You.
Thanks,
Arvind Patil
What about if my previous date is not one day before? Could be 2 or 5 days... How can I calculate the day before no matter how many days in the past they are?
Regards!
I´m having the same question. I want to show daily change in sales vs previous day for a whole month in a bar graph.
How can I accomplish this in Qlik Sense?
did you get any solution