Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
henninghafr
Contributor
Contributor

Creating a dimension from a calculated measure

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, 

2 Replies
Yoshidaqlik
Creator II
Creator II

Hi

you can do:

Aggr(
	Count(Distinct store_id)
,products)

 

Regards

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng
henninghafr
Contributor
Contributor
Author

Thank you so much! worked perfectly!

 

Cheers Henning