topic Re: Improving combination chart in QlikView

Improving combination chart

Tue, 09 Feb 2016 19:05:08 GMT

Dear my friends,

Would like to request your help to improve the view of this chart , I explain ...
I have the following problem , I need to leave refljado the percentage of compliance between actual sales and budgeted under the following script:

= ( 1 + ( ( count ( POLNUM ) -sum ( [ number of policies ] ) ) / sum ( [ number of policies ] ))) * 100

I want to know if it is well written or have a problem in how to approach the solution. For now , only yields a value that does not correspond , ie the calculated field should refljar 91 % and is delivering a 9%

I attached picture, to see what state is the chart , of course thank whoever is interested in helping.

Re: Improving combination chart

Oleg_Troyansky — Tue, 09 Feb 2016 20:41:52 GMT

If I understand your problem correctly, the correct formula should be:

(sum ( [ number of policies ] - count ( POLNUM ) ) / sum ( [ number of policies ] )

, formatted as a Percentage.

Or, even simpler:

1 - count ( POLNUM ) / sum ( [ number of policies ] )

, formatted as a Percentage.

Cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!

Re: Improving combination chart

Tue, 09 Feb 2016 20:58:50 GMT

troyansky thank you very much for your interest in helping me , I replied me what you say but I still results in a value that does not match.

I validated that tab number is not failing, but apparently if I have selected as a percentage value for the expression ' Compliance '

What is it I can do in this case?

Re: Improving combination chart

Oleg_Troyansky — Tue, 09 Feb 2016 21:46:01 GMT

Hi Sergio,

I'm sorry, but I can't understand your problem. Try to get a better translation, or describe it in Spanish and one of the Spanish speakers will respond.

cheers,

Oleg