Qlikview Ignore null value in expression

[Anonymous]

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!!!

[thkarner]

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]

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

[Anonymous]

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]

On which textbox you want to show it ?

the one displaying MIX ?

[Anonymous]

Yes

[teiswamsler]

Hi sristi

this will work with your current data set

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

/Teis

[YoussefBelloum]

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

)