Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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