Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
dilip_solanki
Contributor

How to show new charts after every drill down?

Hi,

I want to represent my data by different charts (pie, bar, column etc). Lets say, at the time of loading bar chart should come, and then after 1 level of drill down, I want to show pie chart (1st level column chart should be hidden here) as so on.

I am expecting below layout:

DrillDown Data.png


After every drill down, data representation should change.


Thanks

Dilip Solanki

Thanks
Dilip Solanki
1 Solution

Accepted Solutions
Partner
Partner

Re: How to show new charts after every drill down?

Ah ok; that should be easy to do:

1) create your 4 charts

2) in the first chart : under adds on, put condition  here:

Capture.PNG

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



Example:

Capture.PNG

select dim1:

=>

Capture.PNG


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

View solution in original post

12 Replies
YoussefBelloum
Esteemed Contributor

Re: How to show new charts after every drill down?

Hi,

you should take a look at the extensions to do this... conditional charts display is not yet available

Re: How to show new charts after every drill down?

Some time ago I used this extension ShowHide Container from Qlik Branch and it works great.

Highlighted
Partner
Partner

Re: How to show new charts after every drill down?

to achieve what you are saying you can use calculation condition under Add-ons->Data handling.

Partner
Partner

Re: How to show new charts after every drill down?

Oh hell no ! that would be perfect !

He wants to be able to change the representation of the SAME chart..

dilip_solanki
Contributor

Re: How to show new charts after every drill down?

Omar,

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:

MultiCharts.PNG

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.

Thanks

Dilip Solanki

Thanks
Dilip Solanki
YoussefBelloum
Esteemed Contributor

Re: How to show new charts after every drill down?

Understood.. unfortunately you will have to take a look at extensions.. you can't do it out of the box

Re: How to show new charts after every drill down?

With the calculation condition under Add-ons->Data handling Andrea suggested you can get a chart to display a simple message instead of visualising dependant on the result of a condition. 

Partner
Partner

Re: How to show new charts after every drill down?

Ah ok; that should be easy to do:

1) create your 4 charts

2) in the first chart : under adds on, put condition  here:

Capture.PNG

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



Example:

Capture.PNG

select dim1:

=>

Capture.PNG


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

View solution in original post

dilip_solanki
Contributor

Re: How to show new charts after every drill down?

Thanks Omar. Its working.

Only thing remaining is, if condition not matched then below block is appearing. Can we hide this as well?

Bar Block.PNG

I think it could be hidden through mashups. But I want to avoid using mashups.

Thanks

Dilip Solanki

Thanks
Dilip Solanki