topic Re: Round down in dimension level in QlikView

Round down in dimension level

amilafdo — Wed, 10 Apr 2019 11:26:52 GMT

Hi,

I am having a master data as below.

eg:

Note: Full box taken by round down (Floor)

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

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

sunny_talwar — Wed, 10 Apr 2019 11:27:45 GMT

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

amilafdo — Wed, 10 Apr 2019 11:35:03 GMT

Hi Sunny,

I am using the below expression for both.

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

Thanks

Amila

sunny_talwar — Wed, 10 Apr 2019 11:36:48 GMT

May be try this

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

amilafdo — Wed, 10 Apr 2019 14:38:46 GMT

Hi Sunny,

Thanks it is working.

Regards

Amila