Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

pavanthota
New Contributor III

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

7 Replies
techvarun
Valued Contributor II

Re: Need a Favour to create a chart

I don't think it is possible in QlikView

qv_testing
Valued Contributor

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

Use Bundle Load

Image Path
B1D:\\QV Community\Images\1.PNG
B2D:\\QV Community\Images\2.PNG
B3D:\\\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,

atkinsow
Valued Contributor II

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.


talk is cheap, supply exceeds demand
pavanthota
New Contributor III

Re: Need a Favour to create a chart

Hi Wassenar

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

Thanks,

Pavan

techvarun
Valued Contributor II

Re: Need a Favour to create a chart

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

Thanks,

Varun

vinod_gadiputi
New Contributor III

Re: Need a Favour to create a chart

HI Pavan,

I think we can achieve your requirement with Grid Chart.

Regards

Vinod Gadiputi

Community Browser