Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

laurent_ankri
New Contributor

Incomprehensible result

Hi

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

Please, Help

That is te first time I see something like tthis

Laurent

Tags (2)
1 Solution

Accepted Solutions

Re: Incomprehensible result

You can add the distinct keyword to the expressions: sum(distinct AFFECTE).


talk is cheap, supply exceeds demand
3 Replies

Re: Incomprehensible result

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.


talk is cheap, supply exceeds demand
laurent_ankri
New Contributor

Re: Incomprehensible result

Hi

Thank for your response

What expression can I use in order to have the good result ?

Re: Incomprehensible result

You can add the distinct keyword to the expressions: sum(distinct AFFECTE).


talk is cheap, supply exceeds demand
Community Browser