I do not wants to change the same chart representation, what I am expecting is like in dashboard we have 4 different objects on dashboard, bar charts, pie charts, data table and KIV.
Please have a look below:
In above SS, we have 4 objects, what I want is, I want to hide pie chart, data table and KIV in initial view. Only Bar charts will be visible at first glance.
On first level drill down, Bar charts will be hide and Pie charts will be shown. Then in second level drill down, Data table will be appeared and pie chart will be hidden. as so on.
So I am trying to find that is there any thing in Qlik sense where we can show and hide objects basis on filter.
Ah ok; that should be easy to do:
1) create your 4 charts
2) in the first chart : under adds on, put condition here:
count(distinct Dimension1) = count(distinct ALL Dimension1)
3) in your 2nd chart, the condition would be :
count(distinct Dimension1) =1
4) in your 3rd chart, the condition would be :
count(distinct Dimension2) =1
4) in your 4th chart, the condition would be :
count(distinct Dimension3) =1
but to do this, when u want to hide the first bar chart; u'll have to have the dimension of the pie: dim2
and to show the table; you'll have to select one value of dim2.
and so on
or u keep the first chart always shown, and do ur drill downs with ur drill down dimension