Data for different periods of time

[Joo525]

Hi there,

I am pretty new at using Qlik, so yopu might be smiling about my question.

I have different products in a table which have changing prices at variable periods of time. Now I want to compare todays price with the price at a certain day in the past.

The time stamps are written in two different columns DD.MM.YYYY (first date: day when the price begins, second date: last day when the price is counting; next row: new dates for startiong and ending of the pricing of the same article.)

I hope I could explain my problems.

Thank you for your help!

[sunny_talwar]

@Joo525 It might be easy to help if you are able to provide some sample data with the output you expect to see from it?

[Joo525]

Ok, I have prepared a data tabel.

At the end I have the request: Give me the price for article 1 at date 15.02.2018.

How do I do that?

Thank you for your help. I am new with Qlik butI hope you can help me.