topic Set analysis with missing values in QlikView

Set analysis with missing values

Thu, 08 Nov 2012 14:48:29 GMT

Hi,

The expression on my chart :

Count({$ <MOTIF -= {'Ne veux pas être recontacté'}>}DISTINCT SOLID_SOL)

In the field MOTIF i have a lot of missing values because it is an optionnal field.

The set analysis excluding the value "Ne veux pas être recontacté" exclude all the SOLID_SOL with a missing value in the field MOTIF.

How can i do to keep the SOLID_SOL with a missing value in the field MOTIF ?

Thanks

Anonymous — Thu, 08 Nov 2012 14:50:13 GMT

try this expresion ----->count ({$<MOTIF-={ } >}distinct SOLID)

Anonymous — Thu, 08 Nov 2012 14:51:40 GMT

follow the doc in this link

Thu, 08 Nov 2012 14:52:41 GMT

in the backend put if(isnull(SOLID_SOL),'MISSING_SOLID_SOL',SOLID_SOL) AS SOLID_SOL

Then Count({$ <MOTIF -= {'Ne veux pas être recontacté'},SOLID_SOL-={'MISSING_SOLID_SOL'} >} Distinct SOLID_SOL)