Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

Show value

Hi all,

in my strighttable  i have  ID as column  but it showing blank  instead of that i want to show the  unknown there

how to do?

null.PNG

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Try This one

If(len(Trim(ID))=0,'UNKNOWN',ID)

If it is not working, try the below.

If(isnull(ID) or len(TRIM(ID))=0,'UNKNOWN',ID)

View solution in original post

5 Replies
Highlighted
Creator III
Creator III

Try This one

If(len(Trim(ID))=0,'UNKNOWN',ID)

If it is not working, try the below.

If(isnull(ID) or len(TRIM(ID))=0,'UNKNOWN',ID)

View solution in original post

Highlighted
Specialist III
Specialist III

i dont want to do in calucalted dimension how can i do into front end only?

Highlighted
Master II
Master II

Maybe

If(Len(Trim(ID)) = 0, 'Unknown',ID)

same answer as Sibin gave

Highlighted
Champion III
Champion III

You can use what Jacob suggested in your straight table Dim ID. Just click edit for your ID field then type like

Calculated dimension

= If(isnull(ID) or len(TRIM(ID))=0,'UNKNOWN',ID)


OR


= Aggr(If(isnull(ID) or len(TRIM(ID))=0,'UNKNOWN',ID), ID)

Highlighted
Creator III
Creator III

Sorry, I didn't get you. what you mean by front end?

Can you please explain little more on your requirement ?

The above formula will work in a script as well as calculated dimension.