Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I don't think it is possible in QlikView
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,
Do you mean like a Scatter 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.
Hi Wassenar
I have not seen any attached example in your reply . Could you please attach it
Thanks,
Pavan
HI Pavan attachment is there already. Please check the original thread directly and not from your inbox.
Thanks,
Varun
HI Pavan,
I think we can achieve your requirement with Grid Chart.
Regards
Vinod Gadiputi