chat in % but not relative - Qlik Community

Report Inappropriate Content · ‎2017-06-28

I have above chart region wise. I want it should show % so I used "relative" tick mark. but it takes sum of all data regionwise.

i.e. =5154+2319+1046+733

I want first region should be calculated by 5154 ( divisor should 5154)

for 2nd 2319

so on..

please help me on this.

Anil_Babu_Samineni · ‎2017-06-28

Narendra, For me question is not clear. Will you able to explain little more

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

kaushiknsolanki · ‎2017-06-28

Hi,

What are the dimension you have used?

You will need to use the expression to get the % instead of the Relative Option.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

sunny_talwar · ‎2017-06-28

Assuming you have the following

Dimensions

Dim1

Dim2

Expression

Sum(Measure)

You can try this expression

Sum(Measure)/Sum(TOTAL <Dim1> Measure)