Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Hi
you can do:
Aggr(
Count(Distinct store_id)
,products)
Regards
Thank you so much! worked perfectly!
Cheers Henning