Count if (A value - B Value)>0

[bbastro1106]

I am new for Qlik sense and I get stuck with a count if expression.

I would like to get a distinct count for [PO ID], if "quantity" - "original quantity" <> 0

My expression as below but I am not able to get the result at all.

Count(if(Quantity-[Original Quantity]>0,distinct [PO ID]))

[ignacio_pena]

Hi,

You can use the next expression:

if(Quantity-[Original Quantity]>0, Count (DISTINCT [PO ID]))

Regards,

[VishalWaghole · Accepted solution]

Try below expression,

If((sum(Quantity)-sum([Original Quantity]))-=0, Count (Distinct [PO ID]))

Thanks,
Vishal Waghole

[bbastro1106 · Accepted solution]

Thanks!

i make some changes on the formula like the following and it works.

if((sum(Quantity))-(sum([Original Quantity]))<0 , Count (DISTINCT [PO ID]))

Thank you!