Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pick a date

Hi All,

Hope all doing well.

I am stuck and I need help.

1. I have calendar and i want to pick a previous day of the row i am processing. If i am processing 07/05/2012, i want to pick 07/03/2012 as previous date because 07/04/2012 is Holiday. If i am processing. I want to skip holidays and week ends. How can I achieve that.

2. I want to get the diff of sum(today's amt - previous day amt) in chart excluding holidays and weekends. I hope it can be dome by set analysis

Thank you in advance.

11 Replies
Not applicable
Author

Thanks,

It is like getting prevoius business days.

LOad script

giakoum
Partner - Master II
Partner - Master II

I dont know what else you need :

2012-08-09_1938.png

giving up!

Sorry I could not help you.