Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
sharmasapna
Contributor III
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
Partner
Partner

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

sharmasapna
Contributor III
Contributor III
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 ?

sharmasapna
Contributor III
Contributor III
Author

Yes

teiswamsler
Partner
Partner

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

)