I think I have corrupted fields in Qlikview which is really strange.
I read in some G/L entries which all have the same fields in Qlikview like Company, Account, Amount. When I create a table, these show up and the formats are the same.
However, when I create a chart and want to sum them up per Company or Account, there is ONE account that is not summed called "9200050". This is really strange as all the other accounts are summed up and there is no format errors in the Amount. You can see my screen shot.
The only field which I can use to sum up amounts is called the Entry number. This is also found in all postings. When I use Entry number, the missing account 9200050 shows up- is that not weird?
My question is : how can data in Qlikview pull up the amount only based on one field in a row? Is it not against all QlikView logic that when you select a company or an account, all other data related to it like Amount is also pulled up?
How to show all accounts even if they are zero? I would add a dummy expression (such as 1+1) and then hide the expression column by changing its width to 0 in a one-off macro like:
set chart = ActiveDocument.GetSheetObject("CH01") set p = chart.GetProperties
set expr = p.Expressions.Item(0).Item(1).Data.ExpressionVisual ' group.expression numbered from 0 expr.ColWidth = 0
