topic Re: > or < in Script in QlikView

> or < in Script

priyarane — Wed, 12 Jul 2017 11:46:51 GMT

Hi Community,

Is there any other to keep < or > in Script part as these are not wroking.

for ex:

if( amt_1 > amt2 ,amt_1,if( amt_1 < amt2 , amt_2)) as amt_F

the above column amt_F have 0 rows, when use the same if statement in front end side and I am getting values.

-Priya

Re: > or < in Script

sunny_talwar — Wed, 12 Jul 2017 11:48:15 GMT

Can you share the script for the table where you are doing this?

Re: > or < in Script

sunny_talwar — Wed, 12 Jul 2017 11:49:20 GMT

You can simplify your expression to this

RangeMax(amt_1, amt_2) as amt_F

But don't think that will resolve your 0 row issue

Re: > or < in Script

priyarane — Wed, 12 Jul 2017 11:55:12 GMT

added

Re: > or < in Script

priyarane — Wed, 12 Jul 2017 11:59:34 GMT

it gives me values but there are 3 scenarios

if( amt_1 > amt2 ,amt_1,if( amt_1 < amt2 , amt_2,if( amt_1 =amt2 ,amt_1))) as amt_F

Re: > or < in Script

sunny_talwar — Wed, 12 Jul 2017 11:59:44 GMT

This seems to be working

Table:

LOAD Amt1,

Amt2,

Alt(Amt1, Amt2) as AmtF1,

RangeMax(Amt1, Amt2) as AmtF2

FROM

[..\..\Downloads\Dat sample.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: > or < in Script

sunny_talwar — Wed, 12 Jul 2017 12:00:46 GMT

This should still work

RangeMax(amt_1, amt_2) as amt_F

Re: > or < in Script

PrashantSangle — Wed, 12 Jul 2017 12:02:22 GMT

if( amt_1 > amt2 ,amt_1, amt_2) as amt_F

will work

Note : check field Name is it amt2 or amt_2

Your data will not help. Please provide proper data.

Regards

Re: > or < in Script

PrashantSangle — Wed, 12 Jul 2017 12:04:10 GMT

In 3rd scenario

if( amt_1 > amt2 ,amt_1,if( amt_1 < amt2 , amt_2,amt_1) )as amt_F

Note : check field Name is it amt2 or amt_2

Regards,

Re: > or < in Script

priyarane — Wed, 12 Jul 2017 12:15:12 GMT

names are fine, I just typed we can correct, take only content pls.

Re: > or < in Script

priyarane — Wed, 12 Jul 2017 12:17:44 GMT

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

Re: > or < in Script

sunny_talwar — Wed, 12 Jul 2017 12:17:52 GMT

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

Table:

LOAD Amt1,

Amt2,

RangeMax(Amt1, Amt2) as AmtF2

FROM

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

(ooxml, embedded labels, table is Sheet1);

Re: > or < in Script

priyarane — Wed, 12 Jul 2017 12:38:08 GMT

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 .

Re: > or < in Script

sunny_talwar — Wed, 12 Jul 2017 12:40:31 GMT

Try with RangeMin()

RangeMin(Bought, Sold) as Final