Hello, could you help me, please, understand how to sparklines property in the table.
I created a very simple model and data to check one of my issues
All values in 2019 have are 10000 and all values in 2020 are 20000 for each month (22 rows in the Data-table).
![GalinaErshova_0-1605647221540.png GalinaErshova_0-1605647221540.png](https://community.qlik.com/t5/image/serverpage/image-id/44322iED2DCBE26EA477F8/image-size/medium?v=v2&px=400)
Then I created a simple table with columns for the current and previous years and dynamics.
When I do not have any filters I get these results. I have 13 points/columns in my sparkline columns. And the last point looks like an average between 10000 and 20000. Why? All values in 2020 are 20000
I specify the field “Year-Month” as a dimension for sparkline indicator to get unique for each row in my Data table.
![res1.png res1.png](https://community.qlik.com/t5/image/serverpage/image-id/44323iE5B59E7AFB8D1052/image-size/large?v=v2&px=999)
In this case, I expect 22 points in the sparkline columns. The total value in sparkline columns is correct.
When I select let say three months in my filter like I also get strange results.
I expected only 6 points in the last sparkline columns(3 for months of 2019 and 3 months of 2020) , but there are 4.
![res2.png res2.png](https://community.qlik.com/t5/image/serverpage/image-id/44324iC08F2193E0ED6D03/image-size/large?v=v2&px=999)
How I should change my formulas in KPI to get dynamics for all dates?
Thanks in advance.
Qvf file in the attachment