Hello, first of all I want to apologies for my English, didn't practiced for a long time, but I will try to explain.
I need to make a graph which represents correlation between price of product and different types of Inflation on same graph. The issue is, Qlik Sense doesn't want to connect some points to make a graph, leaving just some points. I've tried to switch of "include null values", but it connects only few points, not all. My assumptions about this problem:
1. It seems that Qlik Sense thinks, that there missed information and don't know how to fill gaps.
2. There also might be a problem with the format. I mean that I have results for product price weekly, while inflation rate counts monthly. However, my results represented in DD.MM.YYYY form, like I have results for price for 01.01.2020, 07.01.2020, 15.01.2020 and so on, while inflation rate represented by the first day of each month. Like this:
| Date | Product Price |
| 01.01.2020 | 123 |
| 07.01.2020 | 345 |
| 15.01.2020 | 678 |
and the second table
| Date | Inflation 1 | Inflation 2 | Inflation 3 | Inflation 4 |
| 01.01.2020 | 0.7 | 0.2 | 0.7 | 0.4 |
| 01.02.2020 | 0.3 | 0.1 | 0.5 | 0.9 |
| 01.03.2020 | 0.4 | 0.2 | 0.4 | 0.3 |
So, it looks like this format some how breaks the logic of Qlik Sense and it starts to thinks that there are some missing data. This assumption is supported by the last three points of Inflation rate, last three points are connected on all three inflation rate graphs, where I don't have any data for product price.
So, my question is, is there a way I can fix it? Thank you in advance
