Changing dimensions with selections in a chart

[#1]

I have a regional hierarchy (Country, State and City - as three columns)... i want a chart in which the dimension changes automatically depending on what is selected and it shows a level lower than that. So if Country, state and city are Level 1, 2 and 3 respectively and someone selects a country in level 1 - the chart should have Level 2 (states within the city) as the dimension. If a state is selected, it should change dimension to a level 3 (cities within the selected state(s)). With no selections, i want level 1 (country).

Any idea how to do it?

[sushil353]

Please post the sample app

[#3 · Accepted solution]

http://livingqlikview.blogspot.com/2012/01/conditional-dimensions-and-expressions.html

Answer^

[Anonymous]

http://livingqlikview.com/conditional-dimensions-and-expressions-tips-and-tricks/

This blog has moved and the page you are looking for is now located here.