Discussion Board for collaboration on QlikView Layout & Visualizations.
I need help to understand very incomprehensible result in chart (the document attached)
I have 2 tables, linked by the column FAMILLE_NUM
The column "AFFECTE" is equal to 0/1
When I select some families (for example ), the result of the expression sum(AFFECTE) is 2, whereastheres is just one family xho is selected
That is te first time I see something like tthis
Go to Solution.
You can add the distinct keyword to the expressions: sum(distinct AFFECTE).
Your data contains duplicate records. QV doesn't show duplicates, so you can only see it because the count and sum of AFFECTE are 2 instead of 1.
Thank for your response
What expression can I use in order to have the good result ?