Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Firstworkdate with holiday

Dear guys,

I have a problem when use firstworkdate function with holiday list

My field Checkwd: is holiday determine, if Holiday or weekend 1 other is 0

this is my expression. I want find 5 day past without holiday and weekend.


for example: they are holiday in my Tradedate

13 Jul 2018

15 Jul 2018

17 Jul 2018

max(tradedate)=17 Jul 2018 - >and my expected result when apply expression is 9 Jul 2018

Many thanks for your help !

0 Replies