Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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