Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Partner - Creator III
Partner - Creator III

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

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
Not applicable
Author

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

On which textbox you want to show it ?

the one displaying MIX ?

Anonymous
Not applicable
Author

Yes

teiswamsler
Partner - Creator III
Partner - Creator III

Hi sristi

this will work with your current data set

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

/Teis

YoussefBelloum
Champion
Champion

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

)