Set analysis with missing values

[#1]

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]

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

[Anonymous]

follow the doc in this link

http://community.qlik.com/docs/DOC-3155

[#4]

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)