Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Problem by calculating the average

Dear Collegues,

I have an application in which I use three tables:

  1. the first one i have all the production orders sent to our suppliers and its day and supplier

2. the second one i have the "queue" of all the suppliers in every day since today - 400 days ago


3. I have a master calendar. the purpose I created that calendar is to show in a graph all the days, instead of only the days that there was an order release.

How they are related:

The first table is related with the second one by DAY and SUPPLIER. The second one is related with the third one by the day only;

My goal of showing all the day was accomplished, but the thing is: I want to calculate the average queue of all suppliers in a certain day, but only I can do is calculate the average queue of the suppliers that had a realeased order in that day.

Can someone help me with this?

2 Replies

Not exactly sure what you are trying to achieve, so an expected result with the provided data would definitely help.

Maybe it's just about how you are calculating the average, so instead


you could try something like


to calculate the average using all distinct suppliers across all dimensional (date) values.

Contributor III
Contributor III

Stefan, you are right, I guess I wasnt specific enough.

Let´s suppose that my supplier´s base is the one below with it´s WIP on the day 01/01/2017

Supplier WIP.JPG

The average WIP (what I am trying to calculate) in that case is  1.4.

What the application is doing is taking into account only the Suppliers that had a realease date in the day Im willing to check.

Supplier WIP.JPG

In the day 01/01/2017, only the Suppliers A, B and E had an order released to them. For that reason, the application is returning the average as 1.5, instead of 1.4.

Thus, my question is: how to make it take the 5 suppliers into account, instead of only 3?