Activate Variable Function As Field Value

[elmelavi]

Hay Everyone

Lats Say That I Have That Case:

Set v1=If(QTY>2,2,Ceil(QTY));

Set v2=Ceil(QTY);

Set v3=Floor(QTY);

Data1:

Load * Inline [
LOCSTORAGETYPE,LOCUSAGETYPE,QTY,CALCULATION
DD,PI,2.3,v1

SD,HR,0.5,v2

FD,BT,1.3,v3
];

And I Wat It To Give me The Value Within The function in the varible

LOCSTORAGETYPE|LOCUSAGETYPE|QTY|CALCULATION|QtyCharge
DD                             |PI                          |2.3   |v1                     |2

SD                            |HR                         |0.5    |v2                     |1

FD                            |BT                           |1.3   |v3                     |1

There Is Any Script Code/Function Who Can Do That 

If Something Is Not Clear Pls Ask Me And i Will Send QV File

Best Regards Lavi

[rwunderlich · Accepted solution]

You could do something like:

Set v1=If(QTY>2,2,Ceil(QTY));
Set v2=Ceil(QTY);
Set v3=Floor(QTY);

Data1:
Load *,
Pick(Match(CALCULATION, 'v1', 'v2', 'v3'), $(v1), $(v2), $(v3)) as QtyCharge
Inline [
LOCSTORAGETYPE,LOCUSAGETYPE,QTY,CALCULATION
DD,PI,2.3,v1
SD,HR,0.5,v2
FD,BT,1.3,v3
];

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[elmelavi]

Hay Rob

Its Work Amazing Thak You Vety Match

Its Better Then If Statement

Best Regards

Lavi