I am pretty new with QlikView so, please bear with me.
This is my question. I am trying to create a List showing sells by Country for a specific Year. Also, when the client selects a specific country I need to do a drill down that shows the Country, Area and Sales Representative, IN THE SAME LEVEL, instead of showing only area and then Sales Rep.
Is there a way to create a Group dimension where it drill down in to two values at a time (it shows Country, Area and Sales Representative) once the drill down dimension is selected?
Maybe I was not clear explaining it. That's exactly what I have right now and it's what I don't want. If I do that, I will have to drill down each value to get to the last level. My request is, Select the first level value and show all values at once.
You can achieve this easily in version 11, as there is an option to have conditions on dimensions. On the other hand, version 10 (and older ones) do not have this flexibility. However, it can be achieved by having two charts with Show condition like IF(GetSelectedCount(Country)>0,1,0) .