Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dilip1234
Creator
Creator

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
OmarBenSalem

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
Champion
Champion

Hi,

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

Anonymous
Not applicable

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

agigliotti
Partner - Champion
Partner - Champion

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

OmarBenSalem

Oh hell no ! that would be perfect !

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

dilip1234
Creator
Creator
Author

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
Champion
Champion

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

Anonymous
Not applicable

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. 

OmarBenSalem

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

dilip1234
Creator
Creator
Author

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