Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Please post the sample app
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.