Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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 .
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 ?
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.
This is the datamodel. it is good only thing we can declare the MOR_Category(RootCause) Null value as NotApplicable .
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],
Thanks a lot! I did it in Script in middle layer and it worked. Thanks
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.