Populating Dimension Filter Using Only Aggregate Function
Need your help to solve this problem
I have two Dimensions namely : Country and States
i am using the Country dimension as a variable and making its selection possible using a variable drop down. Also i have another dimension filter of states where i am using Qlik Native filter. What i want to do is, whenever i am selecting India in my country variable, i want it to show me only relevant states and if US then the states of US.
for country i am using $(vCountry) and for State i am using [State] dimension as a native filter.
But what happens is that if i select a country India, it shows me all the states of India and when i select a state, except the selected state all the other Indian States disappear. All i want is to retain those indian states as well.
Kind of an urgent and important problem statement for me. Please help out.