Discussion board where members can get started with QlikView.
I'm using the below expression to calculate the percentage values
and my output values are
i want it to be rounded to two decimals and a %age symbol ate the end
8.61% i want like this
and for the below expression
also i want the values as same rounded to two decimals ans a %age symbol
Don't bother multiplying by 100. take that out so you have a decimal fraction then format the result by wrapping it in the num function like this:
or to only format with two decimal places (not changing the actual value):
hope this helps
Can you explain me how it is working
the logic behind the
if you have any idea on this can u please help me out
One of the toughest requirement is, comparing the top n values in current period to the same top n values in the previous period and pre previous period can you please help us in this
The easiest way to achive and the logical way.
Round( xxx , 0.0001) rounds to the nearest multiple of 0.01%, while Num( xxx , '0.00%') formats a number as percentage with 2 decimal places.
Here is the way,
Right Click on your Chart > Chart Properties > Select your expression > Select Checkbox "Relative" > Apply > OK.
I was struggling to get the correct percentage but your comment suggesting "not to multiply by 100" solved it. Thanks!