topic Re: Gauge Chart in QlikView

Gauge Chart

Tue, 12 Jan 2016 17:31:01 GMT

Hi, I've got table of roughly 13,500 patient episodes. Each episode is assigned to 1 of the following 26 clusters (groups of episodes that are similar to each other):

Clusters 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 97, 98, 99 & Non Cluster Activity.

I'm trying to create a gauge chart were:

Segment 1 = sum of the amount of records within clusters 1 - 21
Segment 2 = sum of the amount of records not within clusters 1 - 21

I'm quite new to Qlikview so if anyone let me know whether this is possible, and if so how, it would be much appreciated!

The two tables that I think might be relevant are called "Episodes" & "HRG Description".

Thanks,

Sam

***Update***

Thanks for the responses, I've since done a bit of research on the internet and have created a bar chart using the following 2 expressions:

Clustered

=count( {$ * BM02} [Episodes])

Non Clustered

=count( {$ / BM02} [Episodes])

Were BM02 is a bookmark of a selection I made highlighting clusters 1 - 21.

The "Clustered" expression counts the amount of episodes within clusters 1 - 21. While 'Non Clustered' counts all of the episodes within clusters: 0, 97, 98, 99 & Non Cluster Activity.

The only thing I'm not sure about is how to display this as a circular Gauge Chart. What I want is for the 'Clustered' and 'Non Clustered' expressions to be displayed in segment 1 & segment 2 respectively, so the user can easily see at a glance the ratio between Clustered and Non Clustered activity relative to the current selection.

Do you know if it's possible to display this as a Gauge chart? or will I have to stick with the bar chart?

Thanks!

Re: Gauge Chart

maxgro — Tue, 12 Jan 2016 18:35:51 GMT

some idea in the attachment

Re: Gauge Chart

Anonymous — Tue, 12 Jan 2016 19:41:19 GMT

Try

Segment 1 = sum({< clusters.clusters = {'<=21'} >} clusters.qtd)

Segment 2 = sum({< clusters.clusters -= {'<=21'} >} clusters.qtd)

Re: Gauge Chart

Wed, 13 Jan 2016 12:31:41 GMT

Thanks for the responses, I've since done a bit of research on the internet and have created a bar chart using the following 2 expressions:

Clustered

=count( {$ * BM02} [Episodes])

Non Clustered

=count( {$ / BM02} [Episodes])

Were BM02 is a bookmark of a selection I made highlighting clusters 1 - 21.

The "Clustered" expression counts the amount of episodes within clusters 1 - 21. While 'Non Clustered' counts all of the episodes within clusters: 0, 97, 98, 99 & Non Cluster Activity.

Do you know if it's possible to display this as a Gauge chart? or will I have to stick with the bar chart?

Thanks!