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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

Count of ID for Specific condition

Hi All,

I need to calculate count of SupplierLotID against three layer OrderNumber,OrderLine, AHPLotID where count (SupplierLotID) >1.

I am using below expression:

=Sum(Aggr(Count({<SupplierLotID = {"=Count(distinct SupplierLotID) > 1"}>} Distinct SupplierLotID), OrderNumber,OrderLine,AHPLotID)).


It is not showing correct value.

I am attching my App. Please check "Order Line Count for Multiple" section.

If I select Date= 7 Mar 2017 , it should come as 2.

Please help.

Thanks,

Sarif

2 Replies
Frank_Hartmann
Master II
Master II

May be this:

=Count({<SupplierLotID = {"=aggr(Count(SupplierLotID), OrderNumber,OrderLine,AHPLotID) > 1"}>}  SupplierLotID)

sunilkumarqv
Specialist II
Specialist II

Please try this

=Sum(<SupplierLotID = {"=Count(distinct SupplierLotID) > 1"}>}Aggr(Count({<SupplierLotID = {"=Count(distinct SupplierLotID) > 1"}>} Distinct SupplierLotID), OrderNumber,OrderLine,AHPLotID)).