Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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