Sales %age

[#1]

Hello Everyone

Can you please help me , how to find out Regional Sales %age compare to Total Sales

Region    Sales          Regional Sales%age

A          1000               Need a fromula here

B          1500                    "

C          2000                    "

Total    4500

Sale           

Highly Appreciate for answers

Regards

[rubenmarin]

Hi Asim, try with:

Sum(Sales)/Sum(TOTAL Sales)

"TOTAL" tells QlikView to consider all the values selected, ignoring table dimensions, so each row divides the value of that region to the sales of all regions.

In the 'Numbers' tab of the chart select one of the numeric options (integer, fixed decimal...) and check the option to show in percentage.

[#3]

Thanks, That worked perfect

[maxgro]

[maxgro]

please marks Ruben answer correct and close the thread, thanks