topic Re: How to filter weekend date on chart in QlikView

How to filter weekend date on chart

sr_qlikview — Mon, 25 Mar 2013 18:11:52 GMT

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

Re: How to filter weekend date on chart

Anonymous — Mon, 25 Mar 2013 18:16:13 GMT

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

Re: How to filter weekend date on chart

Gysbert_Wassenaar — Mon, 25 Mar 2013 18:40:33 GMT

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)