Discussion Board for collaboration related to Qlik Education.
I would like to have a count of working day base the loaded list, so I try in the count if command,
it work if it write down the date with string,just as
=Count(if(CALENDERDATE < '15.01.2015', ISOFFICEHOLIDAY))
even work with
=Count(if(CALENDERDATE < today(), ISOFFICEHOLIDAY))
the result should be 104 ( working day)
but it will fail if I try as below
=Count(if(CALENDERDATE < DATADATE, ISOFFICEHOLIDAY))
the result show 402 or some other more.
the DATADATE was flited out by selected list in dataday & datamonth & datayear, if I try the formula in a text object
it show with the right result just as : 05.10.2015
list as below:
Go to Solution.
well, finnally I get it
should be like this
= Count( DISTINCT if(CALENDERDATE < MonthEnd( DATADATE ) and CALENDERDATE >= MonthStart( DATADATE ) and ISOFFICEHOLIDAY = 0 ,CALENDERDATE ))
Try with (Count(if(CALENDERDATE < Date(DATADATE), ISOFFICEHOLIDAY)))
the problem is in the date format ...
still not work,
I even try (
Count(if( num(CALENDERDATE, '0') < num(DATADATE, '0'), ISOFFICEHOLIDAY))
(Count(if(CALENDERDATE < makedate( year(DATADATE),month(DATADATE),day(DATADATE)), ISOFFICEHOLIDAY))
but neither work,
but I agrree that should be issue in format
Coupd you send me your document?
SURE, i HAVE SENT YOU THE FILE WITH MAIL
Do I read it right that the DATADATE returns 05.10.2015 (October 5 or May 10)?
In your hardcoded example it is January 15...
actually, the value of datadate will be change while u selete different datayear & datamonth & dataday. so it is not the key point i think
the datatime format is dd.MM.yyyy