topic Re: Show value in QlikView

Show value

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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?

sibin_jacob — Tue, 07 Aug 2018 13:56:08 GMT

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 — Tue, 07 Aug 2018 14:01:56 GMT

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

MK9885 — Tue, 07 Aug 2018 14:04:48 GMT

Maybe

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

same answer as Sibin gave

vishsaggi — Tue, 07 Aug 2018 14:06:38 GMT

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)

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

sibin_jacob — Tue, 07 Aug 2018 14:06:42 GMT

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.