Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to create a bar chart (Sum of Sales) with last 5 working days ..I have Date filed called Dated_D..I am using QlikView
Please note: Last 5 working day is same as last 5 latest dates as no weekend date is there in my raw data.
Thanks in Advance !!!
Sid
Like this
=sum({$<Dated_D = {'$(date(today()-5))'}>} Sales)
OR
=sum({$<Dated_D = {"today() - (today() - 5) )"}>}sales)
Hi,
Add dimension as Dated_D,
Expression : sum({$<Date_D={'>= $(=(max(Date_D)-4)'}>}Sales)
Thanks.
If we use Today() function then it will include sunday and saturday(non working days)...can we use greatest five dates ..how to do it
If we use Today() function then it will include sunday and saturday(non working days)...can we use greatest five dates ..how to do it