Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

adoteykwame
Contributor

How Can I do this set analysis?

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

2 Replies

How Can I do this set analysis?

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

adoteykwame
Contributor

How Can I do this set analysis?

Thanks Celambarasan for the quick response awesome!

Community Browser