Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

1 Solution

Accepted Solutions
Not applicable
Author

sum( totalValues) / totalSales * 100?

View solution in original post

6 Replies
Not applicable
Author

sum( totalValues) / totalSales * 100?

View solution in original post

Not applicable
Author

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
Author

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
Author

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
Author

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
Author

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

The first really worked after that recreated the chart.

thank you