Creating a dimension from a calculated measure

henninghafr — Mon, 09 Sep 2019 09:18:23 GMT

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,

Re: Creating a dimension from a calculated measure

Yoshidaqlik — Mon, 09 Sep 2019 16:20:08 GMT

you can do:

Aggr( Count(Distinct store_id) ,products)

Regards

henninghafr — Mon, 09 Sep 2019 18:32:16 GMT

Thank you so much! worked perfectly!

Cheers Henning