topic Re: doubt on line chart in QlikView

doubt on line chart

Mon, 04 Feb 2013 18:51:41 GMT

in one chart i should show the data of year 2011 and year 2012 data

and also on my x axis i want the data to be started from 50k instead og 200k where should i change the settings

Re: doubt on line chart

srinivasa1 — Mon, 04 Feb 2013 18:55:10 GMT

do as below

sum({<Year={'2011','2012'}>}sales) and set axes-scale static min and max value and define static step as 50 fromchart properties

Hope it helps u.

Re: doubt on line chart

Mon, 04 Feb 2013 19:31:10 GMT

can clearly say me where should i change the values os axes

Re: doubt on line chart

srinivasa1 — Mon, 04 Feb 2013 19:39:27 GMT

Right clik on chart properies and selcect Axes and Clik Static Step from Scale and define its is as 50..hope it will help

Re: doubt on line chart

Mon, 04 Feb 2013 19:42:37 GMT

no it is not working on the x axis i wanted to see the value 50000 it is not working i am seeing 200000 only again

Re: doubt on line chart

srinivasa1 — Mon, 04 Feb 2013 19:44:32 GMT

Pls attach your sample file

Re: doubt on line chart

Mon, 04 Feb 2013 20:05:57 GMT

and also in that one i wanted to see 2012 weaks and 2011 weaks on y axis

Re: doubt on line chart

Gabriel — Mon, 04 Feb 2013 20:14:58 GMT

Hi Reddy,

This sum({<Year={'2011','2012'}>}sales) for sales figure.

Axes = right click on the chart > Properties > Axes > in the Scale secetion (right hand side of the screen) check Static Min & enter 50000 and Static Max enter 200000.

Click OK

And if you wish to display K as representation of THOUSAND

ight click on the chart > Properties > Number > far down to the right Thousand Symbol enter K and click OK

Let me know if it helps

Regards,

Gabriel

Re: doubt on line chart

Mon, 04 Feb 2013 20:19:56 GMT

thanq it works

Re: doubt on line chart

Gabriel — Mon, 04 Feb 2013 20:29:26 GMT

Glad it worked

Re: doubt on line chart

Mon, 04 Feb 2013 20:44:19 GMT

i wanted to see the 2011 data overlyed by 2012 in the same chart how