Discussion board where members can learn more about Qlik Sense App Development and Usage.
Date formats look like this:
The load script is as follows:
If(IsNull(ValueNullConv), 0, NetWorkDays('Post Date', 'CH Signoff Date')) as [CH DAYS AGED]; //all i see is a zero?
If(len(trim([Signoff Date]))= 0 or [Signoff Date]='NULL' or [Signoff Date]='-', Null(), [Signoff Date] ) as ValueNullConv
(biff, embedded labels, table is AAAATransactions$)
Where [Amount] <> 0;
While testing, i dropped a KPI Object on the page that has an expression like: NetWorkDays('Post Date','Signoff Date')
Any help is appreciated
What is 'CH Signoff Date' you are using in Networkdays() function?
i finally got it working: