Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
venkatbidevelop
New Contributor

NULL Values in Object

Hi  All,

Greetings!

I have  10 columns out of that 3 will be the dimension. (Created as straight chart)

I have used expressions in all the remaining 7 columns/fields and enabled the option suppress null/zero values in presentation tab. But still getting Null value in my object(Result). It is so weird.

Kindly let me know your suggestions.

Thanks in advance.

Regards,
Venkat

5 Replies
MVP & Luminary
MVP & Luminary

Re: NULL Values in Object

Check that the Suppress When Value is Null option is enabled for all dimensions.


talk is cheap, supply exceeds demand
santhiqlik
Contributor

Re: NULL Values in Object

Have you checked "Suppress when value is Null" in Dimensions tab in chart?
venkatbidevelop
New Contributor

Re: NULL Values in Object

Hi Gysbert,

Thanks for your response.

Yeah, I enabled that option already i think some condition inside dimension/expression is blocking it to work properly.

Now I am trying to fix the conditions.

Regards,
Venkat

sasis551
New Contributor III

Re: NULL Values in Object

Hi 

Add calculated Dimensiom==>if (len(column name)>0,column name)

can u try it once?

venkatbidevelop
New Contributor

Re: NULL Values in Object

Thanks all for the suggestions.

I have fixed the issue as mentioned some problem with set expression field.