count of contractor name based on distinct supplier id

[savithri_n_s]

Hi,

Can you please help me in getting count of contractor name>=10 for distinct supplier id? in dashboard 13 of the qvw file.

Also i have attached excel sheet with pink highlighted values i need in expression in qlik view bar chart

Regards,

Savithri

[sunny_talwar]

Try these two

Count(DISTINCT {<[Supplier ID for Counting Unique] = {"=Count([Supplier ID for Counting Unique]) > 10"}>} [Supplier ID for Counting Unique])

Count(DISTINCT {<[Supplier ID for Counting Unique] = {"=Count([Supplier ID for Counting Unique]) <= 10"}>} [Supplier ID for Counting Unique])