topic Expression to count no of rows with same key value in QlikView

Expression to count no of rows with same key value

Thu, 18 Sep 2014 06:18:08 GMT

I am trying to plot a scatter chart.

Data:

Country	Sales	Profit	List Price
USA	200	30	300
USA	500	40	400
South Africa	400	50	500
India	200	20	200
Thailand	50	5	50

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?

Re: Expression to count no of rows with same key value

linusblomberg — Thu, 18 Sep 2014 06:22:30 GMT

Count(country) is that what your mean?

Re: Expression to count no of rows with same key value

Thu, 18 Sep 2014 06:27:49 GMT

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,

Re: Expression to count no of rows with same key value

Thu, 18 Sep 2014 06:31:50 GMT

Yes

Re: Expression to count no of rows with same key value

Thu, 18 Sep 2014 06:32:57 GMT

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

Re: Expression to count no of rows with same key value

linusblomberg — Thu, 18 Sep 2014 06:35:07 GMT

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

Re: Expression to count no of rows with same key value

Thu, 18 Sep 2014 06:38:21 GMT

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

Re: Re: Expression to count no of rows with same key value

Thu, 18 Sep 2014 06:57:46 GMT

Re: Re: Expression to count no of rows with same key value

Thu, 18 Sep 2014 07:34:45 GMT

Hi Pinaki,

Does the above solution work for you?

Regards,