Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am dealing with a line chart in Qlik Sense where my x-axis is a date which I am using as Year/week and my y-axis is of some percentage values.
Eg:
2020/25 | 5% |
2020/35 | 10% |
2020/38 | 15% |
2020/45 | 20% |
2021/5 | 25% |
My graph is only showing 5 values in x-axis but I want to have it in a continuous manner like for 2020/25 it should be 5% and till 2020/34 it should be a straight line and in week 2020/35 it jumps to 10%.
I have tried using the axis as continuous in General>x-axis but it's not working. Is there any other way?
Have you created a master calendar in your data model linked to your transactions? This will build out your potential date points to be reported on.
no...i'll try that...thanks!!
you need to create the values in between the periods, refer this article
https://community.qlik.com/t5/Design/How-to-populate-a-sparsely-populated-field/ba-p/1470637