Percentage is not working as expected in Qlik sense

[nidheesh]

Percentage is not working as expected in Qlik sense

While we are trying to Define the percentage of  available measure and dimension  -percentage is  calculating automatically

[SterreKapteijns]

Can you provide a screenshot of the issue? And some more information about what you are trying to achieve. 

[nidheesh]

Eg:
Measure :     Claim Count(value: 150000)
Dimension :  Claim Age ( values: 40, 60, 100, 200 )

So here few number of claims under 40 bucket and few under 60 bucket and few claims under 100 and few claims under 200 out of the total Claims (150000)

Based on the value - Need to get percentage of each bucket based on the claim count 

[PrashantSangle]

what is your current expression to calculate the %

1: try in simple Straight table

Dimension - Claim Age

% - Count(Claim)/Count(Total Claim)

2: Or use Pie chart (it is best chart to show data as a percentage of a whole)

dimension - [Claim Age]

Measure - Count(Claim)

Regards,

Prashant Sangle

[nidheesh · Accepted solution]

Regarding the option 1

1: try in simple Straight table

Dimension - Claim Age

% - Count(Claim)/Count(Total Claim)

Total claim in not a static one - for example we need to put a date range filter as well , in that cease we  need to get claim % of each bucket within the date range.