topic Re: Guge chart help in QlikView

Guge chart help

Anonymous — Tue, 27 Oct 2015 04:48:32 GMT

Hi,

Good morning every one.

I want to create 3 gauge chart based on type mentioned in the below table

3 expression -Count of each type

count of closed

and count of open

Type	ID	Status
A	188497	Closed
A	188423	Closed
B	188422	Closed
B	188420	Closed
C	188415	Open
A	188391	Open

Re: Guge chart help

sujeetsingh — Tue, 27 Oct 2015 04:55:21 GMT

Use Pie chart it will give you what you need

Re: Guge chart help

Anonymous — Tue, 27 Oct 2015 05:09:54 GMT

Thank you.

Gauge representation is not possible?

Re: Guge chart help

senpradip007 — Tue, 27 Oct 2015 06:10:29 GMT

On what purpose you are looking for the Gauge chart only. As per your requirement, pie chart would be meaningful for the first condition ( "Count of each type").

Re: Guge chart help

robert_mika — Tue, 27 Oct 2015 06:33:04 GMT

Use Expression like this:

=COUNT({<Status={'Closed'}>} Status)/Count(Status)

or for Type

=COUNT({<Type={'A'}>} Status)/Count(A)

=COUNT({<Status={'Closed'}>,Type={'A'} Status)/Count(Status)

But you will end up with 6 gauges:

For each Type status is Open or Close.

Re: Guge chart help

neha_sri — Tue, 27 Oct 2015 07:06:26 GMT

Hi,

I hope this would help.

Regards,

Neha

Re: Guge chart help

robert_mika — Tue, 27 Oct 2015 07:25:11 GMT

Nice one.

Just change the Gauge Setting - MAX to Count(ID) and the Major Unit to 7.

This will not be dynamic thu if we have more types.

Re: Guge chart help

agni_gold — Tue, 27 Oct 2015 11:30:52 GMT

Nice Job Neha