Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
amilafdo
Creator
Creator

Round down in dimension level

Hi,

I am having a master data as below.

eg: 

ItemLot NoQtyNo of items per boxFull Box
AA13083
AA22883
BB12063

Note: Full box taken by round down (Floor)

 

I want to remove the Lot No level in my report & it should be as below.

ItemQtyNo fo items per boxFull Box
A5886
B2063

Currently full box for A is coming 7 but it should be 6.

Please guide me how to prepare this report in Qlikview.

 

Thanks

Amila

1 Solution

Accepted Solutions
sunny_talwar

May be try this

Sum(Aggr(
  Floor(Sum(Qty)/[ No of items per box])
, Item, [Lot No]))

View solution in original post

4 Replies
sunny_talwar

What expression are you using for Full Box? Can you may be share a sample to look at this?

amilafdo
Creator
Creator
Author

Hi Sunny,

I am using the below expression for both.

Floor(Sum(Qty)/[ No of items per box])

 

Thanks

Amila

sunny_talwar

May be try this

Sum(Aggr(
  Floor(Sum(Qty)/[ No of items per box])
, Item, [Lot No]))
amilafdo
Creator
Creator
Author

Hi Sunny,

Thanks it is working.

Regards

Amila