Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to have different chart types for each drilldown

Hi,

I have a main chart which is a line chart. So when i click on the any of the data point it's drilling down  which is again a line chart.

So how can i have differet charts for each drilldown like line,pie, bar? Where can i specify it? Is it possible?

Thanks,

Shree

3 Replies
sasikanth
Master
Master

you can do it by showing a conditional display on the next level charts

in layout of next chart give like

if(getFiledSelection(filed_name)>0,1,0)

and adjust the chart same as First line chart

For more clarity pfa

Not applicable
Author

Hi sasikanth, As i'm using Qlikview personal edition , not able to view the .qvw file which you have sent. So pls can you attach the screen shots so that I'll get a clear picture.

Thanks,

Shree

sasikanth
Master
Master

Hi

suppose you have two charts

First chart

Dimension: ID

Exp: sum(..)

if you want to enable 2nd chart based on the chart1, then give the following condition in chart2-->properties-->Layout

-->conditional

=if(GetFieldSelections(ID)>0,1,0)

Then your second chart will be displayed if you made any selections on first chart

2nd Chart

dimension:NAME

Exp:sum(sal)

similary in 3rd chart -->Properties Layout-->conditional-->

write condition like

=if(GetFieldSelections(NAME)>0,1,0)

Hope you will Understand