Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Karpuz
Contributor II
Contributor II

Stacked area chart forms big downward spikes

Hi community,

I am trying to stack time series on each others. The problem is that it showes unwanted and in my opinion artificial spikes. Also, they only show up when i choose a continuous scale on the x-axis.

I would like to know how I can possibly get rid of them. I am Using Version February 2020

 

It lookes like that:

Karpuz_0-1617803667390.png

before I do the stacking, the areas look like this:

Karpuz_1-1617803702830.png

Karpuz_2-1617804071408.png

Many thanks

 

Labels (3)
2 Replies
Dalton_Ruer
Employee
Employee

Not sure why you are adding MONTHS to some for comparison and YEARS to others for comparison but that could be why some products tail off so much faster than others. 

Copy the table and then drag a Simple Table over it and say "Convert to" so that you can check the actual values to see if they are real or not. 

Continuous scale is good for showing data over time so that end user doesn't miss periods where the data source might be missing a chunk of values. 

Karpuz
Contributor II
Contributor II
Author

Thanks for your suggestion @Dalton_Ruer .
I found out that the graph is not correct. As soon as I zoom in, or remove the Product, the graph looks normal.
I downloaded the table data and tried it in a new app, but the spikes appear again. 

Maybe it is because of the version. (February 2020) I had a similar graph earlier and after we upgraded i suddenly found those spikes in my stacked area graph. If someone wants to try it, the table data is attached.

Cheers
Markus