Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to replace a "blank" field with a value

Hi all,

I have a simple List Box set up as follows:

listbox.png

Quite simply, I want that "blank" value (it is not NULL - but I don't know what it actually is either) to be "None Specified" - I've messed about with various IF statements but I can't manage it.

Could someone point me in the right direction ?

I would really appreciate it.

13 Replies
raajaswin
Creator III
Creator III

=if(isnull([Region of install]),'REPLACEMENT STRING',[Region of install])

Type this in list box expression..

exp.PNG

Not applicable
Author

** BOOM **

That's done it, thanks Sunny.

Thanks all for your help, really appreciated.

Andy

rubenmarin

Hi Andy, in this part of the script:

LOAD Number as SLTN,

     [Project Name],

     [Project Type],

     [Portfolio Priority],

     [Operating System(s)],

     [Region of Install],

     If(Len(Trim([Region of Install]))=0, 'None specified', [Region of Install]) as [Region of Install]
     Stage,

     [Assigned group],

....

Peter_Cammaert
Partner - Champion III
Partner - Champion III

In addition to that, my suggested expression was meant to fix your listbox. Your OP stated that you had problems displaying a string instead of a blank value in a listbox.