# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
New Contributor II

## Converting Pie Chart To Gauge Help

Hello

I have a pie chart that I would like to convert to gauge and wanted to know if its possible.

I have the following Columns

Column Name:                                               Medication

Row (can have any of the following):                 A, B, C, etc..

Column Name:                                               Confirm Status - Patient Level

Row (can have any of the following):                 Yes, No, Partial

Column Name:                                               Confirm Status - Account Level

Row (can have any of the following):                 1, 0

Accounr #MedsConfirm Patient LevelConfirm Account Level
m1aYes1
m1bYes
m1cYes
m22aYes1
m22bNo
v55aNo1
v55bNo

An account can have multiple medications.  The logic is that per account, a medication can have a confirm status of Yes, No, or Partial,   (which is under Confirm Status - Patient Level column).

To group all of the account and their confirm status, we assigned a 1 for all account with the same number.

My Pie Chart has the following Dimension and Measures

Dimension:  =[Confirm Status - Patient Level]

Measure = Sum([Confirm Status - Account Level])/Sum(Total [Confirm Status - Account Level])

I would like to convert into a gauge in order to see rate of only "Yes"  percentage rate.

Please help.

1 Solution

Accepted Solutions
Contributor III

## Re: Converting Pie Chart To Gauge Help

Hi Salamon

Use the same dimension and for the measure use the following:

Sum({<[Confirm Status - Patient Level]={'Yes'}>} [Confirm Status - Account Level])/Sum(Total [Confirm Status - Account Level])

Format the number to a % and make sure you change the Range limits Min and Max to 0 and 1

Thanks

Dan

2 Replies
Contributor III

## Re: Converting Pie Chart To Gauge Help

Hi Salamon

Use the same dimension and for the measure use the following:

Sum({<[Confirm Status - Patient Level]={'Yes'}>} [Confirm Status - Account Level])/Sum(Total [Confirm Status - Account Level])

Format the number to a % and make sure you change the Range limits Min and Max to 0 and 1

Thanks

Dan

New Contributor II

## Re: Converting Pie Chart To Gauge Help

Thank you,

Community Browser