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

[#1]

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

[Anil_Babu_Samineni]

Like this

=sum({$<Dated_D = {'$(date(today()-5))'}>} Sales)

OR

=sum({$<Dated_D = {"today() - (today() - 5) )"}>}sales)

[arasantorule]

Hi,

Add dimension as Dated_D,

Expression : sum({$<Date_D={'>= $(=(max(Date_D)-4)'}>}Sales)

Thanks.

[#4]

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

[#5]

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