Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
What am I doing wrong?
= interval(NetWorkDays(RegistrationDateTime, if(weekday(FirstValidatingDateTime) = 0 , if (match (Floor(FirstValidatingDateTime + 1), Feestdagen_Concat), Floor(FirstValidatingDateTime + 2), Floor(FirstValidatingDateTime + 1)),
if(weekday(FirstValidatingDateTime) = 6, Floor(FirstValidatingDateTime + 2), FirstValidatingDateTime)), Feestdagen_Concat) -2
+ (1-frac(RegistrationDateTime)) + frac(if(weekday(FirstValidatingDateTime) = 6 or weekday(FirstValidatingDateTime) = 0 , Floor(FirstValidatingDateTime), FirstValidatingDateTime)))
bump, anyone?
The most likely explanation is that your variable doesn't contained the right values within the right syntax. I suggest to simplify your variable and expression for the testing - no concat() just two manual values in the variable and no if-loops just the networkday() and then looking how the variable-value is resolved. Within QlikView this could be observed within an empty label for an expression - in Sense I'm not sure, I believe there is a resolution anywhere within the expression-window.
- Marcus
Hi Marcus,
Yes that’s what I thought. I found out my format is DD/MM/YYYY while Qlik uses the standard format MM/DD/YYYY. Unfortunately this doesn’t change anything.
I’ll try a simplified syntax to test