Percentage

[gautik92]

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

[marcus_malinow]

Just take out the * 100.

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

[jyothish8807]

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

KC

[gautik92]

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

[jyothish8807]

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

Regards

KC

[gautik92]

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

[jyothish8807]

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

KC

[krishna20]

Hi gowtham,

Try this hope it helps

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

Regards

Krishna