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.
expression SUM(If(QTY >=3, QTY/3*1.9))
View solution in original post
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