Discussion Board for collaboration related to QlikView App Development.
I am trying to plot a scatter chart.
I am plotting scatter plot of sales vs Profit with dimension Country. Now I need to have a bubble size of USA to be shown big as I have 2 records for USA. But for others it should be of same size smaller to USA.
I need to calculate an expression, which would give me count of rows 2 for USA and 1 for others so that I can vary my bubble size. Can you help me how to calculate this expression?
Please check the attached app.
You would need to have calculated dimensions for the chart to plot across the Sales and Profit.
The count of country would be the expression and would determine the size of the bubble.
Hope this helps.