Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
niharika1234
Creator
Creator

Naming and Selecting Null Values

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.Untitled-2.png

9 Replies
vishsaggi
Champion III
Champion III

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.

niharika1234
Creator
Creator
Author

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 .

Untitled.png

vishsaggi
Champion III
Champion III

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 ?

niharika1234
Creator
Creator
Author

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.


niharika1234
Creator
Creator
Author

Untitled-1.png

niharika1234
Creator
Creator
Author

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

vamsee
Specialist
Specialist

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],

niharika1234
Creator
Creator
Author

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

vamsee
Specialist
Specialist

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