Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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 |
Check the attachment. Is that what you require?
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
Have a year condition in your expression and see what you get...
Sum({<penalty={"<=0"}, Year = {'2015'}>}[curr-assess])
Thanks,
Vinod Kumar V
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
This one?
I see you are using ranking in your graph,In the dimension limits, untick the show others flag
Hope this helps
Also, under the expression table , set the total mode to sum of rows