Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to show all the value in denominator irrespective of dimension

Hi All,

I am restricting the dimension by top 5 . Ex, out of 10 stores  restricting 5.

In measure i want to show 5 stores / total stores.

Currently i am able to get  5 stores / 5 stores. If I do restriction in dimension.

Please advise me

 

 

 

 

9 Replies
Highlighted
Partner
Partner

hi 

how do you limit it to the top 5 stores 

in general 

sum(Sales)/sum(TOTAL Sales) should work 

Highlighted
Creator
Creator

if(aggr(rank(sum(sales)),store)<5 ,store) in dimension

Highlighted
Creator
Creator

Any help would be appreciated ...

Highlighted
MVP
MVP

Did you try Sum(Total sales) as suggested above? Isn't that working?

Highlighted
Creator
Creator

I am using 100% chart .

1 st dimension is quarter 

2nd dimension is if(aggr(rank(sum(sales)),store)<5 ,store)

3 rd Measure is sum(total <quarter > sales)

When i am restricting top 5 store in dimension it showing 100 % of that 5 stores.

I want the actual  % of the store divided by total stores. 

Hope I make you understand ,Thank you

 

 

 

Highlighted

please post some sample data set to work with you

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator
Creator

Please find the sample data.

Highlighted
Creator
Creator

Hi Anil, 

I have attached the sample excel file.

Highlighted
Partner
Partner

Hi Raj,

i have taken Quarter in 1st dimension, only Store field in 2nd Dimension and Measures as Sum(Sales)/Sum(total <quarter> Sales)

and restricted the dimension to top 3 as your data set has 5 values.

here is the attached image of value that i got(Capture 1) and the same i validated in excel(Capture 2).

Regards,

Prashant