Discussion board where members can get started with Qlik Sense.
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
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
please post some sample data set to work with you
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).