Gauge Chart

Report Inappropriate Content · ‎2016-01-12

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!

maxgro · ‎2016-01-12

some idea in the attachment

Anonymous · ‎2016-01-12

Try

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

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

Report Inappropriate Content · ‎2016-01-13