Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
nidheesh
Contributor II
Contributor II

Percentage is not working as expected in Qlik sense

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

Labels (1)
4 Replies
SterreKapteijns
Partner - Creator
Partner - Creator

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

nidheesh
Contributor II
Contributor II
Author

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
nidheesh
Contributor II
Contributor II
Author

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.