topic Re: Line chart help??? in QlikView

Line chart help???

amit_saini — Tue, 11 Nov 2014 11:08:26 GMT

Folks,

I want to create a line Graph , below are the requirements:

X-Axis
Dec-14 to Dec-15
YTD-15

Y-Axis
0 % - 100 %

Data
% ECO Due of Active ECOs --> For this I do have expression so I can use it
YTD-15
Target % ECO Due of Active ECOs --> Target need to be set as 25% , can do by using reference lines

Kindly help here.

Thanks,

Re: Line chart help???

Anonymous — Tue, 11 Nov 2014 11:12:46 GMT

Amit,

For your target line add a new expression with: =0.25

Then you can set its color and line type.

Marc.

Re: Line chart help???

amit_saini — Tue, 11 Nov 2014 11:41:20 GMT

Marc,

Target and % ECO Due of Active ECOs is not an issue , struggling with X-axis from dec14 till dec 15 and Y-axis issue.

Thanks,

Re: Line chart help???

Anonymous — Tue, 11 Nov 2014 11:49:41 GMT

Amit,

If you need this limits for dimension, type this as a calculated dimension:

=if(yourdatefield>='20141201 and yourdatefield<='201512', monthstart(yourdatefield))

I don't know exactly what are you asking for y-axis. If the issue is make it %, then select Relative checkbox in expression tab, or go to number tab and select %.

Hope it helps.

Marc.

Re: Line chart help???

amit_saini — Tue, 11 Nov 2014 11:57:31 GMT

Sorry not working

Re: Line chart help???

Anonymous — Tue, 11 Nov 2014 11:59:41 GMT

Amit,

I can not help further as far as I read. Could you please share a sample?

Marc.

Re: Re: Line chart help???

amit_saini — Tue, 11 Nov 2014 12:14:27 GMT

See the attachment.

Thanks,
AS

Re: Line chart help???

Anonymous — Tue, 11 Nov 2014 15:07:27 GMT

Amit,

In your qvw you have not any relation between owners and dates. If you want to make a chart with these dimensions, you must have your data with owner-date granularity.

Once you get it, just add a dimension with Month, and that's it!

Marc.

Re: Re: Line chart help???

amit_saini — Wed, 12 Nov 2014 05:51:02 GMT

Marc,

I do have date relation now , kindly check .

Also calling Dimension as Month , but not getting exactly what I'm looking for.

See the attachment.

Thanks,

Re: Line chart help???

amit_saini — Wed, 12 Nov 2014 06:02:35 GMT

Kindly help here!

Re: Line chart help???

Wed, 12 Nov 2014 06:20:54 GMT

Hi,

Under the Axes tab, in scale, Check Static Min, Static Max, Static Step and give values 0.0,1,0.25 respectively..

For Y axis..

Hope it helps,

Re: Line chart help???

amit_saini — Wed, 12 Nov 2014 06:27:56 GMT

Pratik,

Thanks for the response , I'm just looking for the solution of

X-Axis

Dec-14 to Dec-15

Rest already has been done.

Thanks,

Re: Line chart help???

Wed, 12 Nov 2014 06:41:52 GMT

ok,

If you have the right dimension in X-axis,

You can go to sort tab, Under it Check the expression checkbox write expr:

=Match(YourMonthName,'Dec-14','Jan-15','Feb-15','Mar-15','Apr-15','May-15','Jun-15','Jul-15','Aug-15','Sep-15','Oct-15','Nov-15','Dec-15')
Hope it works.

Re: Line chart help???

Anonymous — Wed, 12 Nov 2014 08:21:17 GMT

Amit,

You should first check you are loading your data field into the right format, because your Data_Key% field is text format, and should be date or timestamp format. Use Date() function in script to load it properly.

Your Month field is empty. Use MonthName() function on your date field to load it properly.

Once it is done you can go ahead with your chart.

If after this you are still in trouble, please share a qvw again with this changes. Be sure to load more than one date in sample data in order to test your monthly chart.

Marc.