How to have percentage scale in guage chart ???

[#1]

Hi,

My requirement is to have a vertical guage (speedometer) chart as given here.

The sum of deals offered is to be shown in percentage scale from 0 to 100%.

The sum of deals accepted is to be shown as a percentage needle indication.

I could achieve this,

 

But the issue is, sum of deals offered is shown in numbers and I dont get to see an option where I can make it display in percentage.

Checking the 'relative' in expressions tab or 'show in percentage' in numbers tab is not helping

The properties tab is like this now,

Can anyone help me to get this displayed in percentage scale ?????

[cesaraccardi]

Hi,
Are you making a division in your expression? Something like sum(x)/y, where y may represent 100%...

Regards,
Cesar

[kaushiknsolanki]

Hi,

     It will not work because you have only one expression.

     Meaning, To get the percentage you need to have expression where you divide values with something.

     For example.

     Sum(ABC)/Sum(PQR)

     Then you need to give number format as fixed to 2 and show in percentage.

     I hope you understood what i want to say.

Regards,

Kaushik Solanki  

[#4]

Hi Cesar and Kaushik,

I think am realising the missing part.

No wonder my chart dint show in % .. but then, am again a bit confused as to where I have to give what expression.

My scenario is that there may be 10 offers placed out of which 7 offers might have been accepted.

That is Sum(offer_flag) in this case is 10 and Sum(accept_flag) is 7. I want to show a guage where the scale is marked from 0% to 100% and needle shows at 70%.

Presently I had given in expression tab as expression Sum(accept_flag)

..and in Presentation tab, the 'max' value as Sum(Offer_flag)  ...which I now know is not the right method.

Can you please guide me to place the right expression in the right tab.

[kaushiknsolanki]

Hi

    You need to update the expression as

    (sum(Accept_flag) * 100) / Sum(Offer_flag)

    As you said

    (7*100)/10 = 70

    Go to number format and say show in percentage

    Go to presentation give min 0 and max 1

Regards,

Kaushik Solanki

[cesaraccardi]

Hi,

1. You must set your expression this way: *sum(accept_flag)/sum(offer_flag)

*and uncheck the Relative

2. In the Limits, set the maximum to 1 and minimum to 0

3. In presentation set Fixed, and check the Show in Percentage

I think this will solve your problem.

Regards,

Cesar

2011/5/24 sircute123 <qliktech@sgaur.hosted.jivesoftware.com>

QlikCommunity <http://community.qlik.com/index.jspa>

Re: How to have percentage scale in guage chart ???

created by sircute123 <http://community.qlik.com/people/sircute123> in

Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/118757#118757>

[#7]

Thanks Kaushik,

Thanks Cesar.

sum(accept_flag)/sum(offer_flag) --- this worked.

Where can I mark this reply of yours as answer? ..am not getting to see that option ..!!

[cesaraccardi]

Hi,
I think its on the top right of the screen, in the action list.

Regards,
Cesar