Discussion board where members can get started with Qlik Sense.
I have Data from 2Files
Sales ID | Sales Amount
Sales ID | Budget Amount
I Want to pick the Max of (Sales amount and Budget amount) and put it in a new field . need to perform this on the Load script..
For Ex: Sales ID | Sales Amount| Budget Amount|MaxCheck
Something like this?
LOAD * // Data from File1
Sales ID, Sales Amount
LOAD * // Data from File2
Sales ID, Budget Amount
RangeMax([Sales Amount], [Budget Amount]) AS MaxCheck
DROP TABLE Temp;
When Iam running this to the whole data set i dont get the correct Rangemax results.. But when i using it in expression it works
For Ex: when running in script
Sales ID | Sales Amount| Budget Amount|MaxCheck
when using in expression it works correct
But as i need this in load script.. as the file too huge and i would like store it in specific folder