Qlikview dynamic drill down -2 charts linked

[jiwaniakbiar]

I have following Drill Down group.

Region Group = Region>State>City

I am trying to display count of Students through drill down. I can have a single chart which can drill down and it is easy. However my requirement is slightly different. I have to display two charts. 2nd chart should automatically show drill down of first chart selection.

Example:

Let us say chart 1 is showing count of students for (Region) Southern India and Western India. Chart 2 by default should show State-wise split for Southern India (first item on chart1). If i select western India it should show state split for western india. is that possible?         

[israrkhan · Accepted solution]

Yes, You can use the =GetCurrentField(Group Name) to check what is selected in the group...

and in second chart you can use if statement like, if(GetCurrentField(GroupName)= 'State', FirstExp, SecExp)..

Edit: Use the calculated dimension in second chart...

Hope it Helps...

[jiwaniakbiar]

Thank you. One more different question. Is there a way to access these reports over internet?. or alternatively publish them as HTML on click of the button?