topic Re: scatter chart format in QlikView

scatter chart format

alec1982 — Fri, 17 Aug 2012 19:28:58 GMT

Hi,

I have a scatter chart that show sum expenses per location.

I have set the chart to have two colors red and blue. like if the expenses are in 2012 then show it in red otherwise keep it blue.

Now the dots in blue are good size and nice looking but the dots in red are too small.

Is there anyway i can maximize the red dots to be bigger.

Thxs,

Re: scatter chart format

Anonymous — Fri, 17 Aug 2012 19:36:00 GMT

go to chart properties -> presentation -> remove autosize symbol and increase the max bubble size

Re: scatter chart format

alec1982 — Fri, 17 Aug 2012 19:42:31 GMT

Thxs, but that would increase both of them. the red and blue.

Is there anyway I can maximize it when year = 2012.

Thxs,

Re: scatter chart format

alec1982 — Fri, 17 Aug 2012 19:55:24 GMT

Like thi is the method I use for having the two colors.

IF([Year Occupancy Acquisition] = '2012' , argb(255, 238, 49, 36), // Red

argb(155, 0, 147, 208) // Light Blue

Is there anyway to play with the size of the red dots only.

Thxs for your help.

Re: scatter chart format

alec1982 — Fri, 17 Aug 2012 21:13:46 GMT

I tired to use the dimenssion in the expression hoping that will return the same size but it didnt!

Re: scatter chart format

Anonymous — Fri, 17 Aug 2012 22:37:24 GMT

can you please share your application and see how i can help you ?

Re: scatter chart format

Sat, 18 Aug 2012 07:59:04 GMT

Hi Alec

Your scatter chart will have 2 expressions, 1 for x axis and 1 for y-axis. A third expression will set the bubble size. So

Set this in an if statement eg if(year = '2012',10,5)

Regards,

Erica

Re: scatter chart format

SunilChauhan — Sat, 18 Aug 2012 08:11:39 GMT

the bubble size depend on you expenses

if amunt is big then bubble size will be larger and vice versa

hope this help

Re: scatter chart format

alec1982 — Mon, 20 Aug 2012 13:47:01 GMT

Erica,

Thanks for the reply.

The expression that measure the bubbles is Sum(Expenses.)

Would you please give me more details on how it should be written according to your If statement.

Thanks,

Alec,

Re: scatter chart format

Tue, 21 Aug 2012 21:30:29 GMT

Hi Alec

If you would like the 2012 expenses to be bigger, I would multiply the sum(expenses) by some factor for those only.

So the third expression might read something like:

=if(Expense_Year = '2012',sum(Expenses)*10,sum(expenses))

This will increase the size of the red 2012 bubbles but still make them propotionally bigger dependant on the total expenses.

Is this what you are trying to achieve?

regards,

Erica

Re: scatter chart format

alec1982 — Wed, 22 Aug 2012 17:22:13 GMT

That is a nice solutiion but if I do that the end user will have wrong expense nrs when they hyper in the mouse on top of the red dot.

The expenses in this case will be wrong.

Thxs,

Alec

Re: scatter chart format

Wed, 22 Aug 2012 21:52:16 GMT

Your welcome - did you know you can add a 4th expression that will act just as the pop up text to solve this problem.

First, go into the presentation tab in the chart properties and uncheck "pop up labels" to swith off any automated pop up displays.

Then add a 4th expression to the list that evaluates to whatever it is you wish to pop up when you hover over a bubble.

='Year: ' & [Financial Year] & '

Total expenses:' & sum(Expenses)

Under display options, check the "Text as Pop-up" box.

When you hover over a bubble, the pop up will read:

Year: 2012

Total expenses: 10,000

For example.

Regards,

Erica

Re: scatter chart format

alec1982 — Fri, 24 Aug 2012 16:16:05 GMT

Thank you Erica!