# New to QlikView

Discussion board where members can get started with QlikView.

Contributor

## Multiple of 03 as Dimension

Hi,

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.

Thanks

Tags (2)
1 Solution

Accepted Solutions
Honored Contributor II

## Re: Multiple of 03 as Dimension

dimension

if(mod(QTY,3)=0,QTY,null())

expression  SUM(If(QTY >=3, QTY/3*1.9))

suppress null.

Learning never stops.
5 Replies
Highlighted
Valued Contributor II

## Re: Multiple of 03 as Dimension

Something like following

NoConcatenate
QtyTmp:
[Qty
3
4
5
6
7
8
9
11
15
17
20
];

NoConcatenate
Qty:
Qty,
If(Num(right(Floor(Qty/3, 0.1),1))=0, 'Yes', 'No') as [Multiple of 3]
Resident QtyTmp;

DROP Table QtyTmp;

Honored Contributor II

## Re: Multiple of 03 as Dimension

dimension

if(mod(QTY,3)=0,QTY,null())

expression  SUM(If(QTY >=3, QTY/3*1.9))

suppress null.

Learning never stops.
Contributor

Thanks
Contributor

## Re: Multiple of 03 as Dimension

Column name is appearing as if(mod(QTY,3)=0,QTY,null())
Can we change its name

PFA

Honored Contributor II

## Re: Multiple of 03 as Dimension

On the dimesnion tab . select the dimension . On the bottom right , there is a option to give it a label. You can leverage that to change the name.
Learning never stops.