Wrong output of Sum in Graph

[#1]

Hi Qlikview Community,

Can some one explain this to me? It always happen. The total always not equal. I always not use Sum() function because it give me wrong output, I forgot the expression I use on the graph is Sum({<penalty={"<=0"}>}[curr-assess]), i allows not to graph those who has 0 penalty which is I need to display.

Help me to make the total in graph the same in the table below.

Thanks in advance Qlikview Community.

[jonathandienst]

The expression in the graph and the table should be the same if you want the same results. For more detailed help, you will need provide more information - preferably a  sample qvw illustrating the issue.

[#3]

  Hi Sir Jonathan,

He is the table in my Qlikview. Hope you help me.

I cant upload the qvw because it is connected on a Database.

By the way thanks for helping me

Year	Quarter	Payor	Current Tax	Penalty
Total	Total	Total	16616868	6960.06
2013	1		25177	57.9
2013	1	xxxx	644400	1482.12
2014	1	xxxx	644400	773.28
2015	1	Allen Chi Ong	30240	0
2015	1	George A. ong	4800	0
2015	1	Marlyn Serrano	9600	0
2015	1	Patricia Sabrina Narciso	45600	0
2015	1	Rolando Balle & Rosemarie	2750000	0
2013	2		25177	52.86
2013	2	xxxx	644400	1353.24
2014	2	xxxx	644400	644.4
2015	2	Allen Chi Ong	30240	0
2015	2	George A. ong	4800	0
2015	2	Marlyn Serrano	9600	0
2015	2	Patricia Sabrina Narciso	45600	0
2015	2	Rolando Balle & Rosemarie	2750000	0
2013	3		25177	45.32
2013	3	xxxx	644400	1159.92
2014	3	xxxx	644400	386.64
2015	3	Allen Chi Ong	30240	0
2015	3	George A. ong	4800	0
2015	3	Marlyn Serrano	9600	0
2015	3	Patricia Sabrina Narciso	45600	0
2015	3	Rolando Balle & Rosemarie	2750000	0
2013	4		25177	37.78
2013	4	xxxx	644400	966.6
2014	4	xxxx	644400	0
2015	4	Allen Chi Ong	30240	0
2015	4	George A. ong	4800	0
2015	4	Marlyn Serrano	9600	0
2015	4	Patricia Sabrina Narciso	45600	0
2015	4	Rolando Balle & Rosemarie	2750000	0

[Anonymous]

Check the attachment. Is that what you require?

[#5]

Hi sir Ravichandra,

I cant open your qvw file in my PC, can you have a screen capture what is inside on your qvw file?

By the way, thanks for posting your comment here

[#6]

Have a year condition in your expression and see what you get...

Sum({<penalty={"<=0"}, Year = {'2015'}>}[curr-assess])

Thanks,

Vinod Kumar V

[jonathandienst]

Lester Benedict Lazado wrote:

I cant upload the qvw because it is connected on a Database.

The qvw is only connected to the database during the load. One the load is done, there is no connection to the database. Have a look at this:Preparing examples for Upload - Reduction and Data Scrambling

[Anonymous]

This one?

[sasiparupudi1]

I see you are using ranking in your graph,In the dimension limits, untick the show others flag

Hope this helps

[sasiparupudi1]

Also, under the expression table , set the total mode to sum of rows