Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

get one prodcut from each product family

hello guys 

I have a list of 49932 pruducts  contained in  448 product familes

I want to get a table of 448 line with only one product for  each  family (any product )

any ideas how to make it

enclosed is the data file with two colomns

product , productfamily total of 49932 rows

 

thanks

gidon

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Hi,

once you've loaded your product table add :

productFamily:

load min(Product) as myProduct, ProductFamily resident product group by ProductFamily;

you could use max too

regards

View solution in original post

2 Replies
Highlighted
Specialist II
Specialist II

Hi,

once you've loaded your product table add :

productFamily:

load min(Product) as myProduct, ProductFamily resident product group by ProductFamily;

you could use max too

regards

View solution in original post

Highlighted
Creator II
Creator II

Hi Oliver

thanks for your fast response

gidon