How to create a graph

[#1]

Hello,

I was wondering if anyone could help me with creating a graph based on the following information and requirements.  I have 3 columns:

Order_Status:

Completed

Canceled

Null

Order_Month:

Jan 2014

Feb 2014

Mar 2014

Apr 2014

May 2014

Jun 2014

Jul 2014

Aug 2014

Location:

Kirk

East

West

Main

I need a line graph comparing number of completed orders for only two locations by month.  That is, a graph that will have the Order_Month on the X-axis and the Y-axis to have the # of Completed tests only (from Order_Status), for Line 1) Location: Kirk and Line 2) Location: East.

Help is greatly appreciated,

Karen

[Anonymous]

instead of the inline table in the attached file, load your data. the chart should update to show your requirement. if you need more help, let us know. i suggest checking out some videos from qlikshare.com that will help you get familiar with qlikview because they are actual demos.

[jansen28 · Accepted solution]

Not sure if this is what you looking for:

Dim: Month

Exp1:

Count({<[Order Status] = {'Completed'},Location = {'Kirk'}>}Orderid)

Exp2:

Count({<[Order Status] = {'Completed'},Location = {'East'}>}Orderid)

[#4]

This is exactly what I needed, thank you so much!