Discussion board where members can get started with QlikView.
Hi Qlik community,
Currently I'm working on a project which requires to filter our customerbase.
We linked specific labels to our customer key (Debiteur_Key)
I want to replace the '-' with 'None Specified' value. In order to filter exclusively between customer groups.
Currently my script looks like this:
Directory;WFS_WTlabel:LOAD Debiteur_Key,BedrijfType as BedrijfsTypeKlantFROM[TradevsWF.xlsx](xxxx);
WTRADEFILTER:LOADDebiteur_Key,if(Len(Trim(BedrijfsTypeKlant))>0, BedrijfsTypeKlant, 'None Specified') as WTfilter
Drop Table WFS_WTlabel;
But this is not providing me the desired result...
Can someone help me? Thanks in advance!
Thanks Tim, you made think..
And i found the solution;
My initial if(len( statement worked, but first i had to left_join the data and then reload the script.
Thanks for your help!
View solution in original post
Try like this:
NullAsValue *; SET NullValue = 'None Specified';
WTRADEFILTER:LOADDebiteur_Key,BedrijfsTypeKlant as WTfilter
This works for all following Fields:
NullAsValue *; SET NullValue = ‘<NULL>’
This will only effect your desired field:
NullAsValue BedrijfsTypeKlant;SET NullValue = ‘<NULL>
Thanks for your reply!
But still nothing is happening...
I get the same output..
then i think this are not real NULL Values.
Please check the values in Excel.
Maybe this line are already in Excel like "-"
then you can use:
if(trim(FIELD)='-', 'None Specified', FIELD) as FIELD