Discussion Board for collaboration on QlikView Scripting.
Is there any other to keep < or > in Script part as these are not wroking.
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.
Go to Solution.
Try with RangeMin()
RangeMin(Bought, Sold) as Final
Can you share the script for the table where you are doing this?
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
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
This seems to be working
Alt(Amt1, Amt2) as AmtF1,
RangeMax(Amt1, Amt2) as AmtF2
(ooxml, embedded labels, table is Sheet1);
This should still work
if( amt_1 > amt2 ,amt_1, amt_2) as amt_F
Note : check field Name is it amt2 or amt_2
Your data will not help. Please provide proper data.
In 3rd scenario
if( amt_1 > amt2 ,amt_1,if( amt_1 < amt2 , amt_2,amt_1) )as amt_F
names are fine, I just typed we can correct, take only content pls.