Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
valerio347
Contributor
Contributor

NETWORK DAYS WITH NEGATIVE CONDITIONAL

Good morning,

I have a problem with a conditional format applied to the function network days.

 

The formula is :

Count(distinct{$<[SUBJECT]={"=Networkdays([DATE_A],[DATE_B])>7"}>}[SUBJECT])
//=NetWorkDays(YearStart(Today()), yearEnd(Today()))

 

The expectation of this formula is to count:

the times in which the number of days between these two fields is major of seven (without considering saturdays and sundays)

The problem I have occurs when I want to apply to this formula =0 or <0, instead of >7

For example:

Count(distinct{$<[SUBJECT]={"=Networkdays([DATE_A],[DATE_B])<0"}>}[SUBJECT])
//=NetWorkDays(YearStart(Today()), yearEnd(Today()))

 

 

For =0 i have a result but not sure is correct

for <0 the result is zero.

 

 

Is anyone can help me with this formula?

 

Thanks a lot for your support.

0 Replies