Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
njreardo
Contributor III
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.

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

do you complain about the total value?

njreardo
Contributor III
Contributor III
Author

I don't understand...

sunny_talwar

Robin wants to know if you are unhappy with this number

Capture.PNG

Anonymous
Not applicable

me too ...  what result do you expect?

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

njreardo
Contributor III
Contributor III
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?

njreardo
Contributor III
Contributor III
Author

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

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