Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
300sss300
Creator
Creator

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

1 Solution

Accepted Solutions
pradosh_thakur
Master II
Master II

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
Specialist II
Specialist II

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
Master II
Master II

dimension 

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

 

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

 

suppress null.

 

Learning never stops.
300sss300
Creator
Creator
Author

Thanks
300sss300
Creator
Creator
Author

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

PFA

pradosh_thakur
Master II
Master II

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.