topic Re: Activate Variable Function As Field Value in App Development

Activate Variable Function As Field Value

elmelavi — Fri, 15 Nov 2024 21:04:33 GMT

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

Re: Activate Variable Function As Field Value

rwunderlich — Mon, 12 Feb 2024 17:32:30 GMT

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

Re: Activate Variable Function As Field Value

elmelavi — Mon, 12 Feb 2024 18:06:47 GMT

Hay Rob

Its Work Amazing Thak You Vety Match

Its Better Then If Statement

Best Regards

Lavi