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: 
Not applicable

Sum of set analysis

Hi,

I've created some variables that I use to calculate a column in a table(graph). The problem I'm facing now is that when I want to show the total value of that entire column in a pie chart, I either get the message: no values (I've got the dutch version so pardon me if the translation of the error isn't correct), when I set the dimension limits to 5 for example I get the error: all values below limit.

The variables I use:

Streefperc, this is a variable that can be set by a slider and can take a value in the range of 0-1. It is used to calculate a percentage.

Streefhuur = 'Streefperc*Maxhuur'  (Maxhuur is a field, Streefhuur is, for example, 70% of Maxhuur)

In the graph table I then use as expression Streefhuur-Nettohuur, to calculate the marge between Nettohuur and streefhuur.

When I create a pie chart with the same dimension and the expression: SUM(Streefhuur-Nettohuur) I get the errors.

I've also tried to create a separate variable Marge, which calculated Streefhuur-Nettohuur, and tried the sum of that variable, and even a variable that wàs the sum of the variable marge. Still get the same errors. Also tried to expand the vars, so sum($(=$Marge))) of sum($Marge)). No good. I don't think the dimension is the problem because i've tested with several logical dimension, one consists of three groups, so that shouldn't be a limit problem.

I'm really stuck at this and could use some help. Thanks

1 Solution

Accepted Solutions
chematos
Specialist II
Specialist II

Add the dimension Location and use as expression sum(Streefhuur)-sum(Nettohuur), but if there is a negative value in one of the Locations, the pie chart will not be shown

View solution in original post

11 Replies
Anonymous
Not applicable
Author

Hi Ruud,

Do you can to show the QVW file ?

Not applicable
Author

I don't think I can, i still have a personal edition of Qlikview, I'm travelling at the moment but i'll add some clarifying screenshots later this evening

Not applicable
Author

I've added some screenshots of the script, the second example shows the two tables, I want to project the total marge, which is also shown in the top of the table, in a pie chart. The dimension I use consists of 3 values, district 1, district 2 and district 3. When I use this dimension Qlickview gives the error "no values to be shown" (as in example 2) When I change the dimension limit to only show the highest 3, QV gives the error "all values below limit" (example 3)
Hope this clarifies my problem a little bit more!

Not applicable
Author

Can someone please help me?

martinpohl
Partner - Master
Partner - Master

in a pie chart you can't show negative values. It is possible that there are negative values as shown in picture 2.

First try another chart type (bar chart)

Not applicable
Author

Bar chart doesn't work either. It's true that "Marge" can have negative values, but I'm interested in the sum, which is positive. At the top of the table it already shows the sum of Marge: 87.951,69. What I want is that the user can see how this total is divided per district.

martinpohl
Partner - Master
Partner - Master

Can you post a screenshot from the table view?

chematos
Specialist II
Specialist II

Add the dimension Location and use as expression sum(Streefhuur)-sum(Nettohuur), but if there is a negative value in one of the Locations, the pie chart will not be shown

Not applicable
Author

try SUM($(Streefhuur)-Nettohuur)