topic Re: NULL Values in Object in QlikView

NULL Values in Object

venkatbidevelop — Sat, 16 Nov 2024 04:56:29 GMT

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

Re: NULL Values in Object

Gysbert_Wassenaar — Tue, 18 Dec 2018 09:45:04 GMT

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

Re: NULL Values in Object

santhiqlik — Tue, 18 Dec 2018 09:45:41 GMT

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

Re: NULL Values in Object

venkatbidevelop — Tue, 18 Dec 2018 09:55:18 GMT

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

Re: NULL Values in Object

sasis551 — Tue, 18 Dec 2018 10:22:03 GMT

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

can u try it once?

Re: NULL Values in Object

venkatbidevelop — Tue, 18 Dec 2018 15:09:56 GMT

Thanks all for the suggestions.

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