Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
300sss300
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
pradosh_thakur
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.

View solution in original post

5 Replies
vvira1316
Valued Contributor II

Re: Multiple of 03 as Dimension

ts.PNG

 

Something like following

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

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

DROP Table QtyTmp;

 

pradosh_thakur
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.

View solution in original post

300sss300
Contributor

Re: Multiple of 03 as Dimension

Thanks
Highlighted
300sss300
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

pradosh_thakur
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.