Date range matching

PSM — Fri, 28 Feb 2020 16:15:58 GMT

I would like to create a table showing the margin made on all date ranges.

Below is a table merging the To and From dates where the sales and cost price of a product have moved.

Because the dates of sales and cost overlap it creates a few different scenarios and I need to be able to display all.

Thank you for any help 🙂

Re: Date range matching

Brett_Bleess — Wed, 01 Apr 2020 16:22:22 GMT

Given I am confused as heck on the dates, I think you are going to have to provide further information or attach a sample QVW with the data model etc. in order for someone to be able to try to sort things out, as I cannot make any sense of how the dates are aligning, and I suspect that has been the issue for the others too...

The best I can give you otherwise is the Design Blog area, hundreds of how-to posts out here from our experts, so you can search there to see if you can find something that helps, but that is the best I have for the moment.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

topic Date range matching in QlikView

Date range matching

Re: Date range matching