Count a Field when Two Conditions are True

[KKumar92]

Hello Qlik World,

I am working on a procurement dashboard, in order to calculate a particular KPI I have created two measures as follow;

Measure 1 : Received Date - Confirmed Date

Measure 2 : Received Qty - Confirmed Qty

I want to Count the number of Records, where the Value of Measure 1 and 2 is equal to 0 [both conditions has to be true].

I have used the following command in the expression, but I did not get expected results.

(count(if( received_date - confirmed_date = '0' and received_qty - confirmed_qty = '0', order_no)))

Your guidance and support on the above will be highly appreciated.

[Or]

Other than the unnecessary use of quote - you're comparing to the number zero, not the string '0' - I don't see anything wrong.

[Taoufiq_Zarra · Accepted solution]

One solution :

=count({<order_no={"= [Confirmed Date]-[Received Date] =0  "}*{"= [Confirmed Qty]-[Received Qty] =0  "}>} order_no)

an example :

in this case its orderno 1 and 2

[Gabriel]

Hi,

Can you upload a sample data?