Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

urgent

Hi All,

I have 3 fields named country, state and city.

I need to display count of country, count of states inside country and count of cities inside state.

Can anybody plz suggest how to display this information in pleasing form on qlikview.

Thanks in advance!!!

4 Replies
Not applicable

Re: urgent

Hi ,

To Try the AGGR function.

sujeetsingh
Honored Contributor III

Re: urgent

yup just aggregate .

Not applicable

Re: urgent

Can you please explain which objects to use and how to display ?

Not applicable

Re: urgent

just use count(state) and count(city) where ever required if it is independent of selection use count({1}state)

Community Browser