Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Help with a Line Chart

Hey guys, it's my first post.

I need help with a line chart that I am doing.

I have the Dimension set to Fiscal Year - going from 2008, 2009, 2010, 20011, and 2012.

The expression is where I am having trouble.

My Data looks like this:

Supplier #VRR 12M FY10VRR 12M FY11VRR 12M FY09VRR 12M FY12VRR 12M FY08
GS089298.3843400798.0540342795.88192.0146837199.51119119
GS070199.6275978897.6700726998.0540342796.8259136195.881
GS074996.4743559599.6059377599.6275978895.673958696.48787213
GS065292.0146837199.079068669.004778296.4878721399.81146014
GS017999.6059377595.673958699.9919799898.2915978482.59682982
GS152496.8259136195.060500299.8114601482.5968298299.60593775

VRR is a % (out of 100) rating a Vender's (Supplier) Reliabilty.

Fiscal Year is a field in another chart

Supplier# is a keyfield throughout all of my data.

What I need to do is to make a Line Chart that plots the VRR from FY08 - FY12 But I do not know how to set up the Expression, Any help out there?

Do I need to set up a new field or a variable that tells the Line Chart from which VRR box to draw data from?

Tags (1)
1 Reply
Not applicable

Re: Help with a Line Chart

Have you tried building a line chart with the dimensions fiscal year and supplier and an expression like sum(VRR)?

This would show VRR per supplier and year.

Hope that helps.

Matt