topic Re: Naming and Selecting Null Values in QlikView

Naming and Selecting Null Values

niharika1234 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

Please see below screen shot. the Root Cause List box has blank space and that comes to 69%. user wants to select it. as 'Not Applicable' instead of blank . Also in the container the field is Root-Cause and the Blank is not showing up. User wants to add - as Not applicable so that they can select. The Name of root-cause is MOR_Category. Currently I don't want to declare it in Script as it may affect all other calculation. I want to do it in UI level.Please suggest.

Re: Naming and Selecting Null Values

vishsaggi — Tue, 06 Nov 2018 17:02:11 GMT

For your Root cause list box go to General tab -> Field drop down select expression then in expression write below

= If(Len(Trim([Root Cause])) = 0, 'Not Applicable', [Root cause])

Label your listbox as Root cause. Do same for your other fields which has no data or blanks.

Re: Naming and Selecting Null Values

niharika1234 — Tue, 06 Nov 2018 18:03:25 GMT

Thank you so much. I followed your tips and got one of my answer. The red mark I could see Not applicable . Now the blue one is a Chart object the first row is blank and that should be Not applicable too. Also when user select Not applicable in left List box it should show the first row of Green Chart. I hope I clarified my question .

Re: Naming and Selecting Null Values

vishsaggi — Tue, 06 Nov 2018 19:20:54 GMT

Oh for this you have to link this in the data model to reflect in the chart coz you are using this as listbox expression. Or you can give like in calculated dimension expression. Can you share your app i can try on ?

Re: Naming and Selecting Null Values

niharika1234 — Tue, 06 Nov 2018 19:44:51 GMT

Hello,

The data model is good and application is done by other person. Now the user want to change something. The Column name is MOR_Category and it has some null value. They have already developed this and the user does want the Null value blank has to be field with not-applicable.

Re: Naming and Selecting Null Values

niharika1234 — Tue, 06 Nov 2018 19:45:08 GMT

Re: Naming and Selecting Null Values

niharika1234 — Tue, 06 Nov 2018 19:46:25 GMT

This is the datamodel. it is good only thing we can declare the MOR_Category(RootCause) Null value as NotApplicable .

Re: Naming and Selecting Null Values

vamsee — Tue, 06 Nov 2018 20:07:13 GMT

Try adding the following in the code

NULLASVALUE [Root cause];/** You can add multiple columns here */
Set NullValue ='Not Applicable;

Also refer, NULL handling in QlikView

Or while loading the tables, as suggested by vishsaggi‌ try

If(Len(Trim([Root Cause])) = 0, 'Not Applicable', [Root cause]) as [RootCause],

Re: Naming and Selecting Null Values

niharika1234 — Thu, 08 Nov 2018 16:10:51 GMT

Thanks a lot! I did it in Script in middle layer and it worked. Thanks

Re: Naming and Selecting Null Values

vamsee — Thu, 08 Nov 2018 16:27:17 GMT

Glad could be of help.

---------------------------------------

Please close the thread by marking the correct response also. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

https://community.qlik.com/docs/DOC-14806