Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

deerhunter
Contributor

Networkdays not responding - Sense V3.2.3

Date formats look like this:

     07/01/2016, 07/05/2016

     07/03/2016, 07/14/2016

     .....

SET DateFormat='MM/DD/YYYY';

The load script is as follows:

LOAD *,

  If(IsNull(ValueNullConv),  0, NetWorkDays('Post Date', 'CH Signoff Date')) as  [CH DAYS AGED];      //all i see is a zero?

LOAD

  [Post Date],

  [Signoff Date],

  If(len(trim([Signoff Date]))= 0 or [Signoff Date]='NULL' or [Signoff Date]='-', Null(), [Signoff Date] ) as ValueNullConv

FROM [lib://XXXXX/YYYYYYY.xls]

(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')

nothing shows?

Any help is appreciated

Thanks

Tags (1)
2 Replies
MVP
MVP

Re: Networkdays not responding - Sense V3.2.3

What is 'CH Signoff Date' you are using in Networkdays() function?

deerhunter
Contributor

Re: Networkdays not responding - Sense V3.2.3

i finally got it working:

If(IsNull(CHSignOffNullConv), NetWorkDays([Post Date], $(vPullDate)), NetWorkDays([Post Date], [CH Signoff Date])) as  [CH DAYS AGED],

Thanks

Community Browser