set analysis to determine count

[Anonymous]

how to write set analysis for the count of city in a table with columns name,city,mobile number etc.

now need set analysis code for the count for city

[trdandamudi]

Can you be little more specific because if you just want a count then you can use =Count(City). Why do you think you need set analysis. Can you give an example please...

[Anonymous]

for example there are cities like pune,hyderabad,mumbai etc in city column.

then need count for particular city like pune for example in set analysis

i was asked that question.,

[#4]

Hi Kiran

Elaborate more on your requirement with sample data and expected Output so that we will help you

[trdandamudi · Accepted solution]

For what ever reason, if you need the count of a particular city in set analysis you can use the below expression:

For example if you need count for the city 'Pune' then use the below expression:

Count({<City={'Pune'}>}  City)

If you want count for both "Pune" and "Hyderabad" then as below:

Count({<City={'Pune,Hyderabad'}>}  City)

Hope this helps....

[Anonymous]

that helps..

thank you Thirumala Dandamudi

[trdandamudi]

You are welcome and if you think you got the right answer can you please close the thread by selecting appropriate option.

Thanks