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: 
joshrussin
Creator III
Creator III

Counting MTD misses

count.PNG

Having some trouble think this one through.

Trying to count the number of days where Processed_Dash is less than Daily_Target_Dash

I would assume something like this

=Count({$<Processed_Dash < Daily_Target_Dash}, Month = {"$(=Month(Today()))"}, Year = {"$(=Year(Today()))"}>} distinct Date_Dash)

1 Solution

Accepted Solutions
Anil_Babu_Samineni

May be create in script like below

If(Processed_Dash < Daily_Target_Dash, 1,0) as Flag

and expression is

Count({<Flag = {'1'}, Month = {'$(=Month(Today()))'}, Year = {'$(=Year(Today()))'}>} DISTINCT Date_Dash)


Or, One ugly expression this? But, I don't consider it is use

Count({<Processed_Dash = {"=Processed_Dash < Daily_Target_Dash"}, Month = {'$(=Month(Today()))'}, Year = {'$(=Year(Today()))'}>} DISTINCT Date_Dash)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Anil_Babu_Samineni

May be create in script like below

If(Processed_Dash < Daily_Target_Dash, 1,0) as Flag

and expression is

Count({<Flag = {'1'}, Month = {'$(=Month(Today()))'}, Year = {'$(=Year(Today()))'}>} DISTINCT Date_Dash)


Or, One ugly expression this? But, I don't consider it is use

Count({<Processed_Dash = {"=Processed_Dash < Daily_Target_Dash"}, Month = {'$(=Month(Today()))'}, Year = {'$(=Year(Today()))'}>} DISTINCT Date_Dash)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sinanozdemir
Specialist III
Specialist III

Hi,

One solution could be Count(Distinct If(Processed_Dash < Daily_Target_Dash, Date_Dash)). Although, this may affect the calculation time depending on the number of records you have in your data model.


Thanks