# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
Contributor III

## 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.

10 Replies
MVP

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

do you complain about the total value?

Contributor III
Author

I don't understand...

MVP

Robin wants to know if you are unhappy with this number

Anonymous
Not applicable

me too ...  what result do you expect?

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

Contributor III
Author

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

MVP

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?

Contributor III
Author

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

Contributor III
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.

Community Browser