Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
Hi ,
To Try the AGGR function.
yup just aggregate .
Can you please explain which objects to use and how to display ?
just use count(state) and count(city) where ever required if it is independent of selection use count({1}state)