Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

creating Measure with Two Different Dimension

Hi

I have a requirement where i have 3 Tables Fact, Country, Product (Store).

in Fact Table i have a (Sales Measure).

in Country Dimension i have to show the Top 10 Country with sales as below Measure.

SUm({<Country={"=Rank(Sum(sales))<=10"}>}Sales)

Now this is the issue where i'm facing to create a Metric like i need to show [ Count(Store) for Each Country ].

The output should be like

   

CountrySalesNo of Stores
U.K$2,323,443 14
U.S$6,755,890 32
1 Solution

Accepted Solutions
shraddha_g
Partner - Master III
Partner - Master III

This will give you count of stores for top 10 countries.

Count(Distinct {<Country={"=Rank(Sum(sales))<=10"}>}Product)

View solution in original post

3 Replies
sumanta12
Creator II
Creator II

Hi

Please share your input and output data and please elaborate your requirement.

shraddha_g
Partner - Master III
Partner - Master III

This will give you count of stores for top 10 countries.

Count(Distinct {<Country={"=Rank(Sum(sales))<=10"}>}Product)

Anonymous
Not applicable
Author

Shraddha, Thanks for the Response.

didn't have time to look into this busy with other task, just now implemented Its working fine.