Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikians,
Please help me to apply the formula in the data load Editor Qlik Sense.
Below 3 are my line items
SKU
"Line Amount after Discount",
"Total Shipping",
So basically I want to add "Line amount after discount" +"Total Shipping after this I wanted to divide the total by 1.18.
I tried 2-3 different logics but the total is working but not be able to divide it.
Please help me to solve it.
Hi, try
("Line amount after discount" + "Total Shipping")/1.18 as SALE
@KC3 There are many ways to do it.
1. Load
("Line amount after discount" + "Total Shipping")/1.18 as SALE
from Table.
2. Resident Load
Load GMS,
GMS/1.18 as SALE
Resident Table_Name;
3. Preceding Load
Load *,
GMS/1.18 as SALE;
Load *,
("Line amount after discount" + "Total Shipping") as GMS
From Table_Name
All the above methods will yield the same result. Depends on you which one to pick.
Hi, try
("Line amount after discount" + "Total Shipping")/1.18 as SALE
@KC3 There are many ways to do it.
1. Load
("Line amount after discount" + "Total Shipping")/1.18 as SALE
from Table.
2. Resident Load
Load GMS,
GMS/1.18 as SALE
Resident Table_Name;
3. Preceding Load
Load *,
GMS/1.18 as SALE;
Load *,
("Line amount after discount" + "Total Shipping") as GMS
From Table_Name
All the above methods will yield the same result. Depends on you which one to pick.
Thanks everyone for the quick help.