Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
Showing results for 
Search instead for 
Did you mean: 

calculate time difference between different rows with linked documents

Hello folks,

I have the following challenge. I have to present the time difference between linked receipts. this is how my data looks like:


In this example all this rows belong to one sales process. 100001 is the initial quote, followed by the order from customer (200001) on the same day. After 2 days the goods are delivered and the bill 400001 is generated. This is why we have the last 3 columns to link the documents.

My target is to calculate the days between each step (from quote to order; from order to bill):


I have tried the following:

QuoteToOrder: Max({<DocType={Order}>}Date) - Min({<DocType={Quote}>} Date)

OrderToBill: Max({<DocType={Bill}>}Date) - Min({<DocType={Order}>} Date)

In the individual rows the result is '-' but if I activate column-results the column result have the correct numbers (0,2). So my basic idea works, but i need the information redundant in each column.

Can anyone help, please?

1 Reply
Digital Support
Digital Support

Re: calculate time difference between different rows with linked documents

Christoph, any chance you can attach the QVW on this one?  I suspect that would help you get some responses, as it helps if folks can see the data model you have etc. in order to try to come up with the right way to go at things for the use case.  My post will kick things back up, but my hunch is the QVW would really help in this case.

The best I have to try to help would be the following:



To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.