Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
giancarlo_satur
Contributor II
Contributor II

Wrong Percentage Total in a straight table

Hello!!

I need your help, i make a straight table with a one dimension's limit..at this table i have added 2 expression: the first have a simple SUM(Amount) the second is a percentage of the total: SUM(Amount)/SUM(Total(Amount)).

But this second expression is wrong! I see that the "SUM(Total(Amount))" gives me a wrong result.

Can you help me about this?

I attached the table.


Thanks,

Giancarlo

Messaggio modificato da Giancarlo Saturno Hi, i have change the file (not it is more simple)

1 Solution

Accepted Solutions
sunny_talwar

Here you go... this doesn't have Other Banks, but can be included with some more effort

Capture.PNG

View solution in original post

6 Replies
Anil_Babu_Samineni

Sum(TOTAL Amount) gives constant value for all possible values

Sales

10

20

30

Sum(TOTAL Sales) returns 60.

So, In straight table, Sum(Sales)/Sum(TOTAL Sales) //It will work as below

10/60 

20/60  

30/60 

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

I think dimension limits will cause problem here... you will have to use Rank() function to restrict to the top 17. Would you be able to point out which expressions are we looking at? There seems to be few of them in your chart... not sure which one are you working with....

giancarlo_satur
Contributor II
Contributor II
Author

Hi Sunny,

Thanks for your replay, i have attached a new file..the expression is the secon '% on total'...i try qith an if with Rank() function but it dosen't work

sunny_talwar

This would require some doing.... You have a very complicated dimension.... I can look at this once I am home if somebody have not already responded and resolved your issue

sunny_talwar

Here you go... this doesn't have Other Banks, but can be included with some more effort

Capture.PNG

giancarlo_satur
Contributor II
Contributor II
Author

It works! Thank you very much!!