Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: ¿How count with networkdays and other statement?

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


talk is cheap, supply exceeds demand
Not applicable

Re: ¿How count with networkdays and other statement?

Does not work

Re: ¿How count with networkdays and other statement?

Works fine here.


talk is cheap, supply exceeds demand