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: 
Not applicable

Drill down from Straight table to a line chart

I have a Straight table and a line chart.

The staight table has data for various years. The line chart has data for one year divided into months

If the user clicks on a cell in the straight table, I want to show the line chart. Is it possible to do that in Qlikview?

Thanks,

Nihar

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes. Assume your yesr field is named "Year". Add a Show condition on the Layout pane of the line chart:

=GetPossibleCount(Year)=1

-Rob

Not applicable
Author

Hi Rob,

Thanks a lot for the reply!

Two issues:

1) I dont want the line charts to be conditionally enabled. They should always be active and they reside in a different sheet from the pivot table. What I want is, when someone clicks on the year field of the pivot table, they should be redirected to another sheet where the line chart resides (and the line chart should become active).

2) Year is not a dimension of the chart. Its an expression thats part of the pivot table(for a few reasons, I cant make year to be a dimension, its got to remain an expression). So, I cant directly use '=GetPossibleCount(Year)=1'

Really appreciate your help.

Thanks,

Nihar