topic Help for create Scatter or Grid chart in QlikView

Help for create Scatter or Grid chart

Sat, 15 Jun 2013 05:19:20 GMT

Hi all

I have a table like this:

I want to show this information on a Scatter or Grid chart with this parameters:

Axes:

X = Brand

Y = Total Sale

Size of Bubble = Total Space

Could you please help me to create this chart.

Thanks in advance.

Regards,

Ashkan

Sat, 15 Jun 2013 06:25:46 GMT

Hi Ashkan,

Are you facing any specific issue?

I have attached file which have simple Grid Chart.

Please explain detailed

Sat, 15 Jun 2013 07:09:54 GMT

Hi karthiks

Thanks for your reply.

I have edited my table in first post.

I created a grid chart like this:

But I want every brand has one bubble (Occupied sapce by every brand).

I wish I could explain what I want.

Gysbert_Wassenaar — Sat, 15 Jun 2013 07:41:17 GMT

Use a calculated dimension =aggr(sum(Sale),Brand) instead of Sale. See attached qvw

Sat, 15 Jun 2013 08:28:55 GMT

Hi Gysbert

Unfortunately I can't open this attachment, because I'm using Personal Edition.

Could you please write the scrip or explain what you did.

Thank you in avdance.