topic Re: Percentage in QlikView

Percentage

gautik92 — Mon, 17 Nov 2014 10:39:22 GMT

My Variance % formula is =(Variance/(Sum( {$<Year={$(=Max(Year))}>} TotalVolume)))*100

How can i convert it into 100 my values are exceeding 100%

Thanks in Advance

Re: Percentage

marcus_malinow — Mon, 17 Nov 2014 10:42:47 GMT

Just take out the * 100.

when you define the number format as percentage, QlikView takes care of multiplying by 100

Re: Percentage

jyothish8807 — Mon, 17 Nov 2014 10:46:57 GMT

Hi Gowtham,

First of all check variance < (Sum( {$<Year={$(=Max(Year))}>} TotalVolume)

If yes then remove *100 from the forumula and in chart property go to number tab select integer or number and select %.

Hope it helps.

Regards

Re: Percentage

gautik92 — Mon, 17 Nov 2014 10:49:13 GMT

variance<(Sum( {$<Year={$(=Max(Year))}>} TotalVolume)

Re: Percentage

jyothish8807 — Mon, 17 Nov 2014 10:58:14 GMT

Then try removing *100 from the formula any try what i suggested.Hope it works.

Regards

Re: Percentage

gautik92 — Mon, 17 Nov 2014 11:07:09 GMT

if the value of variance is less than sum the variance exceeding 100%

Re: Percentage

jyothish8807 — Mon, 17 Nov 2014 11:33:00 GMT

Are you dividing it with Sum(Variance) if yes then you should get the right output.Over here i guess the denominator is less than the variance or may be beacause of negative and positive numbers.

Regards

Re: Percentage

krishna20 — Mon, 17 Nov 2014 14:12:40 GMT

Hi gowtham,

Try this hope it helps

=( (Variance/(Sum( {$<Year={$(=Max(Year))}>} TotalVolume)))*100 ) /100

Regards

Krishna