How to filter weekend date on chart

[sr_qlikview]

I have to develop a 7 day (only weekday) rolling chart for sales. how to filterout weekend dates on dimension ? any function to handle this or best possible way?

ex: my chart should display sales for below dates.

Mar 25

Mar 22

Mar 21

Mar 20

Mar 19

Mar 18

mar 15

[Anonymous · Accepted solution]

Usually the best way is to create a field for workdays in the script.  If oyu have field Date, for all days, it will be

if(weekday(Date)<5, Date) as WorkDay

Regards,

Michael

[Gysbert_Wassenaar]

See attached example

Instead of max(Date) you could use today() if you only want to calculate the last 7 workdays from today: sum({<Date={'>=$(=firstworkdate(today(),7))'}>}Sales)