Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
stavc
New Contributor

count and group by

hi all,

i need to do a count and group by.

I have a straight table in which i have one column of costumers and the other column is products the costumer ordered.

i need to know how many products ordered made each costumer.

for example:

costumer        product

1                            table

1                            table

1                             chair

1                             computer

 

in this case i need to see that costumer 1 ordered 2 tables, 1 chair and 1 computer.

 

thank you all

1 Reply
MVP & Luminary
MVP & Luminary

Re: count and group by

Add customer and product as dimensions to your straight table and =count(product) as  measure


talk is cheap, supply exceeds demand