Discussion board where members can get started with QlikView.
I have Quantity (QTY) as Dimension in straight table whereas there is only one expression
SUM(If(QTY >=3, QTY/3*1.9))
Now this expression shows all values >= 3 in QTY Dimension Field 3,4,5,6....... But I need only Multiple of 03 (3,6,9....) as dimension in QTY field
Just wanna help whether it will be done by adding calculated dimension or in expression.
Go to Solution.
expression SUM(If(QTY >=3, QTY/3*1.9))
Something like following
NoConcatenateQtyTmp:LOAD * Inline[Qty345678911151720];
NoConcatenateQty:LOADQty,If(Num(right(Floor(Qty/3, 0.1),1))=0, 'Yes', 'No') as [Multiple of 3]Resident QtyTmp;
DROP Table QtyTmp;
Column name is appearing as if(mod(QTY,3)=0,QTY,null())Can we change its name