Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sharmasapna
New Contributor III

Qlikview Ignore null value in expression

Hi Team

I have requirement where i want to ignore null values in the expresison, and consider/display the value which is avialable

PFA qvw.

Thanks in advance!!!

7 Replies
thkarner
Contributor III

Re: Qlikview Ignore null value in expression

Hi, in your example the UoM contains an empty string. This is different than a null value. A null values wouldn´t be displayed in the list box. Before developing a solution it would be necessary to know whether you want to have an empty string or a null value in the UoM field. -- BR Thomas

YoussefBelloum
Esteemed Contributor

Re: Qlikview Ignore null value in expression

Hi,

Use this:

=if(len(Trim(UoM))<>0, UoM)


It will remove everything related to null/Blanks etc.


and if you really want to remove these blank values ONLY when you select 2, use this:


=if(GetFieldSelections(Number)=2, if(len(Trim(UoM))<>0, UoM),UoM)

PFA

sharmasapna
New Contributor III

Re: Qlikview Ignore null value in expression

I need to display KG in text object. As per your solution you are restricting it in the List box. I want it to be ignored or restricted in text object.

YoussefBelloum
Esteemed Contributor

Re: Qlikview Ignore null value in expression

On which textbox you want to show it ?

the one displaying MIX ?

sharmasapna
New Contributor III

Re: Qlikview Ignore null value in expression

Yes

teiswamsler
Contributor II

Re: Qlikview Ignore null value in expression

Hi sristi

this will work with your current data set

only( {< UoM={"=len(Trim(UoM))>0"} >}UoM )

/Teis

YoussefBelloum
Esteemed Contributor

Re: Qlikview Ignore null value in expression

It is the same thing, removing the Blank / nulls cells..

before giving you a solution on that textbox, I need to know what is the logic behind this:

=if(

GetPossibleCount(UoM)>1 ,'MIX',UoM

)

Community Browser