topic set analysis to determine count in QlikView

set analysis to determine count

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: set analysis to determine count

trdandamudi — Thu, 18 Aug 2016 16:22:16 GMT

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...

Re: set analysis to determine count

Anonymous — Fri, 19 Aug 2016 04:50:29 GMT

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.,

Re: set analysis to determine count

Fri, 19 Aug 2016 05:50:09 GMT

Hi Kiran

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

Re: set analysis to determine count

trdandamudi — Fri, 19 Aug 2016 10:43:39 GMT

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....

Re: set analysis to determine count

Anonymous — Sat, 20 Aug 2016 07:00:22 GMT

that helps..

thank you Thirumala Dandamudi

Re: set analysis to determine count

trdandamudi — Sun, 21 Aug 2016 11:22:25 GMT

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

Thanks