If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am trying to replace the '-' with Zeros. I have looked around and tried alot of surgestions but nothing has worked yet.
Does anyone know how to do this?
I've very new to Qlik so the more you could spell it out the better...
Could you please elaborate on a resident or preceding load?
I have tried doing this in a load statment but it hasnt worked, the field name is MATNR as its from Sap:
[Sales Document: Item Data]:
POSNR as Item,
IF(isNull(MATNR),0,MATNR) as [Material Number],
ARKTX as Description,
ZMENG as [Target quantity in sales units],
WERKS as Plant,
ERDAT as [Loading Date],
FIXMG as [Delivery date and quantity fixed],
PRCTR as [Profit Center]
where WERKS = '001'
PRCTR = 'BBVX'
FIXMG = 'X'
// STORE * FROM [VBAP] INTO [LIB://FolderConnection/VBAP.qvd];
// DROP TABLE [VBAP];
At the top of that Section of data in the load editor, name that table something like StartData:
Then in a new section in the load editor create a resident load by doing the following:
If(IsNull("Material Number"), 0, "Material Number") as "Material Number
Drop Table StartData;
Lets do this a little different. I was trying to say place this script in a whole new section in the load.
Press that Plus sign to add a new section in the load editor. In that new section lets put the following script:
If(IsNull("Material Number"), 0, "Material Number") as "Material Number"
Resident [Sales Document: Item Data];
Drop Table [Sales Document: Item Data];
Thanks, get what you mean now.
I have added a new load section which is under my table and added the script,
I ran the load script and then it came up with this
In your first table name don't do the rename of the Material number, leave it as is. Then in the second table, change Material number in the formula to your name in the first load. Should read as follows:
If(IsNull(MATNR ), 0, MATNR ) as "Material Number"