Display alternate states used on chart x axis as filter
In QlikSense, I have a bar chart for displaying sales for regions. I have used alternate states to display sales against Country and State. I have another chart for displaying revenue, where in I have similar Region, country and state on X axis.
Now my requirement is to have a filter which will have 3 values - Region, Country and State. When I select 'Region', both the charts should show sales and revenue for all the regions. When I select 'Country' , both the charts should show sales and revenue for all the Countries and like wise for States.Basically how to populate 3 columns as filter selection values ?
Hope I am clear with my requirement. Please find the attached screenshot for reference.