Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression to count no of rows with same key value


I am trying to plot a scatter chart.

Data:

  

CountrySalesProfit List Price
USA20030300
USA50040400
South Africa40050500
India20020200
Thailand50550

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?

8 Replies
linusblomberg
Creator II
Creator II

Count(country) is that what your mean?

Not applicable
Author

Hi Pinaki,

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.

Regards,

SK

Not applicable
Author

Yes

Not applicable
Author


I am using Personal edition. hence cant open this file. can u please give me the formula?

linusblomberg
Creator II
Creator II

Does that not show you what you want? the yellow bubble (USA) is twice the size.

Not applicable
Author


Sorry Linus. I am not able to open your QVW file.

Not applicable
Author

18-09-2014 14-54-55.png18-09-2014 14-55-12.png18-09-2014 14-55-33.png

Not applicable
Author

Hi Pinaki,

Does the above solution work for you?

Regards,

SK