Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
N_avya1
Contributor III
Contributor III

Number Of Days With Working Duration >0

Hello, 

I have a Field Working Duration and Wanted to Create a master Item for working Days

Number of working Days with Working Duration>0 

Please Correct me if this expression is not correct .

 

Count({<Working_Duration={">0>"}>}distinct DAY_DATE)

 

Labels (1)
2 Solutions

Accepted Solutions
MatheusC
Specialist II
Specialist II

@N_avya1 

Try it this way:

one option is to create a flag

if(Count({<Working_Duration = {">0"}>}Distinct DAY_DATE) = 1,1,0)

bringing the value of 1 for days Working_Duration>0


and in this 2nd example it will bring the total number of days with Working_Duration>0 aggr per Day, Month
sum(aggr(if(Count({<Working_Duration = {">0"}>}distinct DAY_DATE) = 1,1,0),DAY_DATE,DAY_Month))

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!

View solution in original post

MatheusC
Specialist II
Specialist II

@N_avya1 

Did you manage to resolve this topic?

If you have finished, close the topic given the accepted solution.

Thanks!

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!

View solution in original post

2 Replies
MatheusC
Specialist II
Specialist II

@N_avya1 

Try it this way:

one option is to create a flag

if(Count({<Working_Duration = {">0"}>}Distinct DAY_DATE) = 1,1,0)

bringing the value of 1 for days Working_Duration>0


and in this 2nd example it will bring the total number of days with Working_Duration>0 aggr per Day, Month
sum(aggr(if(Count({<Working_Duration = {">0"}>}distinct DAY_DATE) = 1,1,0),DAY_DATE,DAY_Month))

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
MatheusC
Specialist II
Specialist II

@N_avya1 

Did you manage to resolve this topic?

If you have finished, close the topic given the accepted solution.

Thanks!

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!