Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hay Rob
Its Work Amazing Thak You Vety Match
Its Better Then If Statement
Best Regards
Lavi