Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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)

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
Highlighted

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)

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

Highlighted
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