Discussion Board for collaboration related to Creating Analytics for QlikView.
Hello, I have to present in a graphic display, the percentage of the total value of the goal has already been achieved until the last month.To generate the total billed, do sum total billed X, with the total billed Y.How to calculate the percentage of total revenues compared to the total value of the target?How to mount this expression?
Go to Solution.
sum( totalValues) / totalSales * 100?
See 120,000 invoiced (sales), meta 137,000, which% of the target has been reached?I did as stated above but I returned as shown in the picture.
sum(sales) / sum(meta) * 100
87.591% has been reached.
looks like you're workings are correct, but you're decimal point is one point off.
Try not *100 and just set it up to show as a % in the number tab.
See Wallerjc excludes the chart and created again, following the first tip you gave me, and it worked. Do not understand why but it worked.thank you
Can you please mark my answer as correct/helpful if it helped you. I think I get some points or something for helping out on here.
Yes, I marked the first and second answer correct as util ok.The first really worked after that recreated the chart.thank you