Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I want to handle null values in qlikview application so how to handle the same ?
try this
Null is supressed in List box I think it is empty spaces, use Trim() to remove blank spaces.
Try like this in script
Load
*,
If(Len( Trim (Field) ) > 0 , Field) AS FieldNull
FROM DataSource;
Or in front end give calculated dimension
If(Len( Trim (Filed) ) > 0 , Field)
Hope this helps you.
This is giving an error
if(Len( Trim (Filed) ) > 0 , Field)
what error your getting?
its working for me
A:
load * Inline
[
OrdDate,TempID,ID #,So,
01.2018,1,01,10
11-23,2,02,11
1,1,,1
0,3,4,
];
LOAD * ,
Date(Date#(OrdDate,'MM.YYYY'),'DDMMYYYY') as New,
if(len(Trim([ID #]))>0,[ID #]) as First
Resident A;
This comma in this expression is giving an error
if(Len( Trim (Filed) ) > 0 , Field) when I am using in calculated dimension
its working for me
Hi
I want all (total stores)(circled in red) to have equal values in all three seasons when I select LFL_Flag as Yes (circled in black),so How to do that ?