topic Re: Create Graphic Display in QlikView

Create Graphic Display

Mon, 29 Jul 2013 13:46:28 GMT

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?

Re: Create Graphic Display

Mon, 29 Jul 2013 15:14:42 GMT

sum( totalValues) / totalSales * 100?

Re: Create Graphic Display

Mon, 29 Jul 2013 17:41:52 GMT

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.

Re: Create Graphic Display

Tue, 30 Jul 2013 08:02:18 GMT

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.

Re: Create Graphic Display

Tue, 30 Jul 2013 11:29:57 GMT

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

Re: Create Graphic Display

Tue, 30 Jul 2013 11:34:52 GMT

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.

Re: Create Graphic Display

Tue, 30 Jul 2013 11:38:05 GMT

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

The first really worked after that recreated the chart.

thank you