topic Re: Change x-axis scale in QlikView

Change x-axis scale

Mon, 11 Sep 2017 13:52:17 GMT

Hi,

I am a very new user of Qlik Sense. I encounter some issues with the visualisation of a line chart. So I've computed the following line chart :

Dimension : 100*aggr(Rank(Price,1,1),date)/(max(total aggr(rank(Price),date))+1)

Measure : Price

And I would like something more similar to this (It is the same graph computed on Excel) :

The general trend seems more clear in the second chart. So I wanted to know how to get a more similar chart in qlik (maybe change the scale of the X-axis and only represent integer value would reduce the length of the first graph)

Re: Change x-axis scale

Anil_Babu_Samineni — Mon, 11 Sep 2017 14:04:06 GMT

Can you provide QVF file?

Re: Change x-axis scale

vishsaggi — Mon, 11 Sep 2017 14:11:41 GMT

May be try using scatter or grid chart.

Re: Change x-axis scale

Mon, 11 Sep 2017 14:33:38 GMT

Sorry I am not sure to be able to provide you the QVF file but here's an excel with the data regarding to my question (the dimension and measure of the line chart are mentioned in my first post)

Re: Change x-axis scale

Thu, 14 Sep 2017 09:50:37 GMT

Hi, anyone knows how to resolve my problem ?

I thank you in advance

Re: Change x-axis scale

shraddha_g — Thu, 14 Sep 2017 10:04:01 GMT

Create a Dimension by Using Class(Fieldname*100,20)

Else in Script,

if(PercentField >0.00 and PercentField<=0.20,'20',

if(PercentField >0.20 and PercentField<=0.40,'40',

if(PercentField >0.40 and PercentField<=0.60,'60',

if(PercentField >0.60 and PercentField<=0.80,'80',

if(PercentField >0.80 and PercentField<=1,'100',

if(PercentField =0.80 ,'0')))))) as NewField

Use this new field in Dimension

Re: Change x-axis scale

Thu, 14 Sep 2017 10:09:01 GMT

Hi, I didn't get this condition : if(PercentField =0.80 ,'0'). Could you give me more explanation please ?

Thank you for your answer I will test it right now

Re: Change x-axis scale

shraddha_g — Thu, 14 Sep 2017 10:14:39 GMT

Here you are comparing Values of Fields to create buckets shown in the chart created in Excel..

Re: Change x-axis scale

shraddha_g — Thu, 14 Sep 2017 10:15:28 GMT

And sorry for mistake

if(PercentField >0.00 and PercentField<=0.20,'20',

if(PercentField >0.20 and PercentField<=0.40,'40',

if(PercentField >0.40 and PercentField<=0.60,'60',

if(PercentField >0.60 and PercentField<=0.80,'80',

if(PercentField >0.80 and PercentField<=1,'100',

if(PercentField =0.00 ,'0')))))) as NewField