Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

soniasweety
Valued Contributor 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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
sibin_jacob
Contributor III

Re: Show value

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)

5 Replies
Highlighted
sibin_jacob
Contributor III

Re: Show value

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)

soniasweety
Valued Contributor III

Re: Show value

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

Khan_Mohammed
Honored Contributor II

Re: Show value

Maybe

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

same answer as Sibin gave

vishsaggi
Esteemed Contributor III

Re: Show value

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)

sibin_jacob
Contributor III

Re: Show value

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.