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: 
Not applicable

inventory calculation

I have a Problem to solve in my Application for inventory calculation...

I have a Table like this:

                 Time        Inventory         Hours in Stock   

Incoming    08:00            10

Outgoing    11:00             5                       03:00

Outgoing     15:00            3                       07:00

Incoming

How i can calculate the "hours in Stock" and the "nventory" fields?

3 Replies
Sokkorn
Master
Master

Hi,

Can you make a manual result that you looking for?

Regards,

Sokkorn

Not applicable
Author

i want to calculate inventory like this:

10 - outgoing(5) =5 - outgoing(2) =3 ..

and the "Hours in Stock " like:

08:00 to 11:00 = 03:00

08:00 to 15:00= 07:00

Sokkorn
Master
Master

Hi,

Use function ABOVE().

Edit: Example for Inventory Expression: Inventory - ABOVE(Inventory)

Regards,

Sokkorn