How to implemented in Qlikview

[#1]

Hi,

I have a excel sheet that sheet contains requirement like...

in my table i have fields like Country, State, City,Village, and ID. So my requirement is first when i select  india in Country field and next select Maharashtra in State field  and select Mumbai in City field, and Select Ghansoli in Village field i will get a value like 120 (Count(ID)).

After that i select Mumbai and Pune in City field i got a value like 130(Count(ID)).

After that i added two values like 120+130=250 will be coming, The 250 is the value of "Complete required ".

I need to display these vales on Table.

The sample out put is:

So tell me how can i achieve this..

Thanks advance

[Digvijay_Singh]

Can you share sample data, not sure but may be you need to use set expression like this -

Count({<Country={'India'},State={'Maharashtra'},City={'Mumbai'},Village={'Ghansoli'}> + <Country={'India'},State={'Maharashtra'},City={'Mumbai','Pune'}>}ID)