Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master III

Line chart help???

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,

AS

13 Replies
Anonymous
Not applicable

Amit,

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

Then you can set its color and line type.

Marc.

amit_saini
Master III
Master III
Author

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,

AS

Anonymous
Not applicable

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.

amit_saini
Master III
Master III
Author

Sorry not working

Anonymous
Not applicable

Amit,

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

Marc.

amit_saini
Master III
Master III
Author

See the attachment.

Thanks,
AS

Anonymous
Not applicable

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.

amit_saini
Master III
Master III
Author

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,

AS

amit_saini
Master III
Master III
Author

Kindly help here!