Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
GE
Contributor
Contributor

How to work with sparkline in qlik sense

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

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

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

 

 

 

 

 

How I should change my formulas in KPI to get dynamics for all dates? 

Thanks in advance. 

 

Qvf file in the attachment

Labels (1)
0 Replies