Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Create Graphic Display

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?

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Create Graphic Display

sum( totalValues) / totalSales * 100?

6 Replies
Not applicable

Re: Create Graphic Display

sum( totalValues) / totalSales * 100?

Not applicable

Re: Create Graphic Display

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.111.png

Not applicable

Re: Create Graphic Display

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.

Not applicable

Re: Create Graphic Display

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 youqqqq.png

Not applicable

Re: Create Graphic Display

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.

Not applicable

Re: Create Graphic Display

Yes, I marked the first and second answer correct as util ok.

The first really worked after that recreated the chart.

thank you

Community Browser