Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calculating percentage for each row in a table

Hi everyone,

I'm trying to figure out how to calculate the percentage (=((Sum([CY 2017]) - Sum([Prev.CY 2017])) / Sum([Prev.CY 2017]))) for each row in the table accuractely. Here's a picture for reference.

tables percentages.PNG

As you can see, the numbers aren't accurate. Please help.

10 Replies
sunny_talwar

As you can see, the numbers aren't accurate. Please help.

I am not sure I see the inaccurate numbers? What are you expecting to see? How does the raw data looks like?

Anonymous
Not applicable
Author

do you complain about the total value?

Anonymous
Not applicable
Author

I don't understand...

sunny_talwar

Robin wants to know if you are unhappy with this number

Capture.PNG

Anonymous
Not applicable
Author

me too ...  what result do you expect?

Just post a sample please and explain what you're expecting.

Anonymous
Not applicable
Author

The percentages are too high. They should be much lower than what they are...

sunny_talwar

May be check if individual part of the expressions make sense

1) Sum([CY 2017])

2) Sum([Prev.CY 2017])

Can you share a screenshot with Region as dimension and the above two as expressions?

Anonymous
Not applicable
Author

The total is correct. It's the regions that are not...

Anonymous
Not applicable
Author

I'm expecting the variances for Asia, as an example, to be 0.1% for 2017, 0.0% for 2018, 0.1% for 2019, 0.2% for 2020, 0.6% for 2021, and 0.6% for 2022.