7 Replies Latest reply: Jul 26, 2017 6:41 AM by vinod gadiputi

# Need a Favour to create a chart

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:

CustomerSum(Sales)
ABC65
XYZ20
TRE56
HJK75
fgh45

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

• ###### Re: Need a Favour to create a chart

I don't think it is possible in QlikView

• ###### Re: Need a Favour to create a chart

I have created few bubble images.

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

 Image Path B1 D:\\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,

• ###### Re: Need a Favour to create a chart

Do you mean like a Scatter Chart?

• ###### Re: Need a Favour to create a chart

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.

• ###### Re: Need a Favour to create a chart

Hi Wassenar

Thanks,

Pavan

• ###### Re: Need a Favour to create a chart

Thanks,

Varun

• ###### Re: Need a Favour to create a chart

HI Pavan,

I think we can achieve your requirement with Grid Chart.

Regards