Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ramshoney
Contributor

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
Honored Contributor III

Re: creating Measure with Two Different Dimension

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

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

3 Replies
sumanta12
Contributor II

Re: creating Measure with Two Different Dimension

Hi

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

shraddha_g
Honored Contributor III

Re: creating Measure with Two Different Dimension

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

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

ramshoney
Contributor

Re: creating Measure with Two Different Dimension

Shraddha, Thanks for the Response.

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