Hello everyone, I have a question and I hope you can help me.
I have a bunch or reports for specific date, but those reports are made irregularly, some of them made weekly, some of them made after two weeks from previous. So, I need to show in table the difference in prices from previous date, since month start and since year start.
Lets assume that I have reports for Jan 1 2020, Jan 8 2020, Feb 1 2020, Feb 10 2020 and Feb 14 2020, with the prices for goods A, B and C for each mentioned date. So, if I choose Feb 14 in a filter, I need to make table like this
| Good | This week | Since month start | Since year start |
| A | difference in Price between Feb 14 and Feb 10 | difference in Price between Feb 14 and Feb 1 | difference in Price between Feb 14 and Jan 1 |
| B | | | |
| C | | | |
and so on.
So, my question is, can it be made via Qlik Sense or I have to calculate this results manually for each report and then load to app?
Thank you in advance.
