6 Replies Latest reply: Aug 23, 2018 10:12 AM by Daniel Haiduc

# Define X Axis Min/Max on continuous scale Line Chart

Hello everyone,

I am very to new to QLIK Sense so bare with me

I have a line chart that display a CDF function for a set of values. Y axis is from 0 to 1 (0 to 100%) and I can see that this is configurable.

But the X axis is not configurable under Appearances and I would like it to start at 0 and end with a value of my choice. My dimension is a calculated one and obviously the X Axis will start with the lowest value and ends with the highest value from the data set. My calculated dimension looks like:

=if(Duration]='No' AND [Direction]='Down' AND [TestModule]='ABC' AND [Status]='Successful', Class([BlaBla]],1))

Any way to achieve this? I was reading around and could only find how to limit the max value so far.

Thanks

Daniel

• ###### Re: Define X Axis Min/Max on continuous scale Line Chart

Without looking at your data/expressions, i'd say you have two options:

- edit your line chart expression to account for your desired conditions with set analysis

• ###### Re: Define X Axis Min/Max on continuous scale Line Chart

Thanks William. I will give it a go, but for now I have not used the Data Handling Add-on and I have no clue how it works

• ###### Re: Define X Axis Min/Max on continuous scale Line Chart

Hi William

Maybe I did not get it yet, but also using a calculation under data handling will not work, because this option is from my understanding for filtering out big data-sets, which means will even more constrain my selection. Which again is not what I want.

Cheers, Daniel

• ###### Re: Define X Axis Min/Max on continuous scale Line Chart

Hi Daniel,

can you create your intervals in script as a dimension table? Then you could use this as a dimension and by including zero values you should achieve what you want.

Juraj

• ###### Re: Define X Axis Min/Max on continuous scale Line Chart

Hi Juraj,

You solution will not work because my Dimension has to be more or less based on the same data-set as used in the Measure calculation. The X Axis will indeed change but so does also the data that is being represented which is not what I want.

Thanks anyway. Cheers, Daniel

• ###### Re: Define X Axis Min/Max on continuous scale Line Chart

So far it seems that the only way I can achieve this is by adding fake data in the column that it is used to create the CDF function. I gave it a go and it worked. One should be carefull to give it a few attributes so that it can be left out from the calculation, but it can be added to the Dimension (X-Axis).

Not the nicest way, but it does the job for now.

Weird that QLIK Sense does not let you configure such a simple and basic parameter.