Need a Favour to create a chart

[pavanthota]

Hi all,

I need a help to create a chart, I have a dimension called customer and measure is sales. I need to create the circles based on the measure values, and the circle radius depends on the measure values.

Ex:

Customer	Sum(Sales)
ABC	65
XYZ	20
TRE	56
HJK	75
fgh	45

Based on the above table need to show 5 circles  as one object. The highest radius of the circle belongs to 'HJK' customer due to highest sales and lowest radius of the circle is 'XYZ' customer due to lowest sales.

Please check my requirement if anyone can help.

Thanks,

Pavan

[techvarun]

I don't think it is possible in QlikView

[qv_testing]

I have created few bubble images.

Make one excel image name and Image path, as mentioned below

Use Bundle Load

Image	Path
B1	😧\\QV Community\Images\1.PNG
B2	D:\\QV Community\Images\2.PNG
B3	D:\\\QV Community\Images\3.PNG

Note: if you have 1 to 100 values OK, we can create bucket wise

like 1 to 10 values = Small Circle

11 to 20 = Little Increase Circle

.......

75 to 100 = Big Circle etc........

But, if you have more 1000 values, not make sense.

PFA,

[Anonymous]

Do you mean like a Scatter Chart?

[Gysbert_Wassenaar]

You should use a bar chart for this.

But you can create the dysfunctional monster you're asking for by using a Grid chart with an extra dummy dimension. See attached example.

[pavanthota]

Hi Wassenar

I have not seen any attached example in your reply . Could you please attach it

Thanks,

Pavan

[techvarun]

HI Pavan attachment is there already. Please check the original thread directly and not from your inbox.

Thanks,

Varun

[Anonymous]

HI Pavan,

I think we can achieve your requirement with Grid Chart.

Regards

Vinod Gadiputi