Getting the count of a field where no selections are made

[DekAnku]

Hello Everyone, 

I am stuck in one problem from quite some time now. My problem is like this

I have Markets in Column A. Each markets have some number of dealers in them. 

Dealers are stored in Column B.

My requirement is : 
When i select any dealer from column B, I want the code to compute the total number of dealers in the market of the dealer selected. 

for Example:
If I select D10 from dealers in qlik, then it should first check which market this dealer belongs to i.e M1 and then give me the count of distinct dealers in M1 i.e 3

[marcus_sommer · Accepted solution]

Try it with: count({< Market = p(Market), Dealer >} distinct Dealer)

[DekAnku]

Wow. 
This is like a perfect Solution. 

Couldnt Thank you more @marcus_sommer  🙂