Using Filters

[maheshgandem]

Hi,

Need a help, i have few city names, while doing count of these cities, I do not want few city names to be appearing while fetching the data, pls help me with the same.

sample city names given below

from the below, need to apply one more filter of city names

=COUNT({<cust_id = {"=count(cust_id)>2"},location={'HYD_Retail'}>} DISTINCT complaint_no)

1.Hyd

2.Chennai

3.Mumbai

4.Delhi

4.Bangalore

out of the above, i only need Hyd & Chennai and rest of the city names should not get populated

[oknotsen]

I think you are missing the P of the P function.

Set modifiers with implicit field value definitions ‒ Qlik Sense

[sumanta12]

=COUNT({<cust_id = {"=count(cust_id)>2"},location={'HYD_Retail','Chennai'}>} DISTINCT complaint_no)

[agigliotti]

to understand better what you are trying to achieve post a sample app.