topic Re: How to create a graph in QlikView

How to create a graph

Tue, 19 Aug 2014 17:57:09 GMT

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

Re: How to create a graph

Anonymous — Tue, 19 Aug 2014 18:18:19 GMT

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.

Re: How to create a graph

jansen28 — Tue, 19 Aug 2014 19:30:34 GMT

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)

Re: How to create a graph

Wed, 20 Aug 2014 13:43:41 GMT

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