Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
priyarane
Contributor III

Re: > or < in Script

it is not correct data as per scenario... I have added some clarity data.

MVP
MVP

Re: > or < in Script

Is this not the output you want? If not, then what do you want?

Capture.PNG

Table:

LOAD Amt1,

    Amt2,

    RangeMax(Amt1, Amt2) as AmtF2

FROM

[..\..\Downloads\Dat sample (1).xlsx]

(ooxml, embedded labels, table is Sheet1);

priyarane
Contributor III

Re: > or < in Script

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 .

MVP
MVP

Re: > or < in Script

Try with RangeMin()

RangeMin(Bought, Sold) as Final