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: 
carotravaglini
Contributor II
Contributor II

Line chart does not show correct data from pivot table - RangeSum() and Above()

Hi, 

I have the next pivot table:

table.PNG

 where the column number 8 is calculated as column7/column3

This columns (3 and 7) are the sum of the above per year

The function is: 

(RangeSum(Above((Count (Legajo) * 9 - Fridays),0,12)))/(RangeSum(Above(((count(distinct(leg_numero)) - count(distinct(if([leg_fecegr.autoCalendar.Date]<[Fecha.autoCalendar.Date],leg_numero))) - count(distinct(if([leg_fecing.autoCalendar.Date]>[Fecha.autoCalendar.Date],leg_numero)))) * (Days_w*9 - Fridays)),0,12)))

This is working well, the problem is when I want to represent the column number 8 as a line chart:

Line chart.PNG

The values that are shown here are not the same that i have in the pivot table and i dont understand why.

Later, i found out that if i group by year and use the months as the line, the values are the expected, but i want to see them as is shown in the picture above. 

Here is the line graph group by year and using month as line:

line chart 2.PNG

I think it may be because of the rangesum or the above, but im not sure.

Is there any reason why the values are not showing correctly in the first option? Because the funcion is the same! 

Thank you!! 

Caro

Labels (1)
1 Reply
carotravaglini
Contributor II
Contributor II
Author

I still haven't found the solution.