Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Just take out the * 100.
when you define the number format as percentage, QlikView takes care of multiplying by 100
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
variance<(Sum( {$<Year={$(=Max(Year))}>} TotalVolume)
Then try removing *100 from the formula any try what i suggested.Hope it works.
Regards
KC
if the value of variance is less than sum the variance exceeding 100%
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
Hi gowtham,
Try this hope it helps
=( (Variance/(Sum( {$<Year={$(=Max(Year))}>} TotalVolume)))*100 ) /100
Regards
Krishna