Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

¿How count with networkdays and other statement?

Hi Guys,

I need a help to desing the formula to count a number days range with a field filter.

NEED:

I need to count the quantity of tickets that have the state On Going and are from 0 and 5 networkdays. The count in networkdays is from the "Starline" to Today().

MY SOLUTION:

Im using the next formula but doses not work:

=Count({$<[Status]={'On Going'},{networkdays(Min(Startline), Max (Today())}={'>-1,<6'}>}[Ticket])

     

TicketOwnerStartlineStatusNetworkdays
1Task121/02/2016On Going16
2Task221/02/2016On Going16
3Task317/03/2016On Going-4
4Task417/03/2016On Going-4
5Task517/03/2016On Going-4

Best regards.

3 Replies
Gysbert_Wassenaar

count({<Status={'On Going'}, Ticket={'=Today()-Startline<6 and Today()-Startline>=0'}>}Ticket)


talk is cheap, supply exceeds demand
Not applicable
Author

Does not work

Gysbert_Wassenaar

Works fine here.


talk is cheap, supply exceeds demand