topic Re: Need a Favour to create a chart in QlikView

Need a Favour to create a chart

pavanthota — Thu, 20 Jul 2017 07:32:07 GMT

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

Re: Need a Favour to create a chart

techvarun — Thu, 20 Jul 2017 08:36:37 GMT

I don't think it is possible in QlikView

Re: Need a Favour to create a chart

Nagaraju_KCS — Thu, 20 Jul 2017 09:20:29 GMT

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,

Re: Need a Favour to create a chart

Anonymous — Fri, 21 Jul 2017 22:18:09 GMT

Do you mean like a Scatter Chart?

Re: Need a Favour to create a chart

Gysbert_Wassenaar — Sat, 22 Jul 2017 09:38:45 GMT

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

pavanthota — Wed, 26 Jul 2017 09:36:09 GMT

Hi Wassenar

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

Thanks,

Pavan

Re: Need a Favour to create a chart

techvarun — Wed, 26 Jul 2017 10:22:36 GMT

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

Thanks,

Varun

Re: Need a Favour to create a chart

Anonymous — Wed, 26 Jul 2017 10:41:51 GMT

HI Pavan,

I think we can achieve your requirement with Grid Chart.

Regards

Vinod Gadiputi