topic How Can I do this set analysis? in QlikView

How Can I do this set analysis?

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

This Field "CATEGORY" has three records namely Laptop,Desktop,Workstation.And what i basically want to count the total number of Laptops, Desktop and Workstation seperately to display them.

Thanks

How Can I do this set analysis?

CELAMBARASAN — Wed, 07 Mar 2012 10:24:58 GMT

Hi,

You mean like this

Count({<Category={'Laptop'}>} FieldName)

Count({<Category={'Desktop'}>} FieldName)

Count({<Category={'Workstation'}>} FieldName)

Or use Straight table have category as dimension

Count(FieldName) as Expression

FieldName can be any unique field or You can use Category

Celambarasan

How Can I do this set analysis?

Anonymous — Wed, 07 Mar 2012 10:36:10 GMT

Thanks Celambarasan for the quick response awesome!