Help with set analysis

[Anonymous]

I need help with the following expression -

Count({$<field={'NULL'}>}field)

However, I want it to do the opposite of this.  I want it to ignore the 'NULL'.  I tried replacing the '=' with '<>' but that didn't work.

Any suggestions?

Thanks

Greg

[beck_bakytbek]

Hi Greg,

you can make in script the flag, and with flags exclude the zero values within your charts

beck

[Anonymous]

I don't understand

[Anil_Babu_Samineni]

Then use this, BEfore = there is one -(Hyphan)

Count({$<field -={'NULL'}>}field) // I am assuming you have NULL name of value in that field

[annafuksa1]

try

Count({$<field=-{'NULL'}>}field)

[Anonymous]

Thanks.  That seems to work but the expression looks like it has errors even though it says 'Expression OK' -

[Peter_Cammaert]

Just ignore the wiggly lines underneath your expression. The syntax checker doesn't know about negation nor does it know about compound operators (e.g. -=). Indeed "Expression OK" says it all...

[annafuksa1 · Accepted solution]

its a bug in Qlikview

it is working perfectly fine (I use is in many calculations:))

you can use as well

Count(if(field<>'NULL',field)

[annafuksa1]

but use Count({$<field=-{'NULL'}>}field) not Count({$<field-={'NULL'}>}field) as they are working if different way (I will strongly recommend to test it and see )

[Peter_Cammaert]

A small warning: taking everything except NULL in this way, will include all InitialSDSStatus values not currently selected. If you want to exclude NULL from the currently selected values, use

Count({$<InitialSDSStatus -= {'NULL'}>} InitialSDSStatus)