Creating a dimension from a calculated measure

[henninghafr]

Hi everybody, 

I am new til qlik and I am having trouble creating a dimension from a calculated measure.

I have a table with the different products.

This table is connected to a second table which is connected to a third where I can find the different stores.

I would like to create a dimension where I count how many stores that have the specified product. 

I can make a measure by using  product as dimension and counting "store_id".

However, I want to use this value as a dimension to be able to for example filter on the number of products that are available in eg 3 or 4 stores.

Is there a simple solution tom this?

Cheers Henning

Product, Stores, 

[Yoshidaqlik]

Hi

you can do:

Aggr(
	Count(Distinct store_id)
,products)

Regards

[henninghafr]

Thank you so much! worked perfectly!

Cheers Henning