Discussion Board for collaboration on QlikView Scripting.
it is not correct data as per scenario... I have added some clarity data.
Is this not the output you want? If not, then what do you want?
RangeMax(Amt1, Amt2) as AmtF2
[..\..\Downloads\Dat sample (1).xlsx]
(ooxml, embedded labels, table is Sheet1);
Sorry Sunny for confusion here,
let me clarify with good data and requirement
Bought > Sold – Use Sold
Bought < Sold – Use Bought
Bought = Sold – Use Bought or sold .
Try with RangeMin()
RangeMin(Bought, Sold) as Final