How to calculate with values over different tables based on criteria
Hello to everybody,
I face the following challenge. But maybe it is no challenge for you outside in the large Qlikview Community.I would like to calculate with values of several different tables.
Based on Orders, Delivery takes place that will be invoiced "as delivered". That is, i.e. 100hours of Consultancy has been ordered, but only 20hours have been delivered in the current month. Those hours are invoiced. Of course only those hours of need be calculated, that correspond to one ProjectNo.
How to get an exact overview of those hours open (not delivered yet and of course not invoiced yet) and the corresponding expected amount of revenue to invoiced in future on this project?
I tried to use left joins and concatenats but I didn't get through.