topic Creating charts - Help please :) in QlikView

Creating charts - Help please :)

Fri, 10 Feb 2012 09:28:27 GMT

Hi All,

I'm hoping this is a relatively straight forward question.

I have 2 tables holding data like below:

Table 1:

Status_ID	Status
1	Completed
2	In Progress
3	Not Started

Table 2:

REC_ID	Status_ID
764856	1
342454	3
124652	2
278095	1

I am trying to create a bar chart which counts the amount of REC_ID's completed and I want the axis to display the Status by looking up the Status_ID in Table 1.

Does anybody have any instructions as to how to do this? I am currently trying to display it in a Bar Chart.

Thanks

Victoria

Creating charts - Help please :)

CELAMBARASAN — Fri, 10 Feb 2012 09:38:25 GMT

Hi,

Use Status as Dimension.

Expression as Count({<Status={'Completed'}>} REC_ID)

Are you looking for this?

Celambarasan

Creating charts - Help please :)

Fri, 10 Feb 2012 09:49:04 GMT

Thank you, That works a treat