topic Re: Qlikview dynamic drill down -2 charts linked in QlikView

Qlikview dynamic drill down -2 charts linked

jiwaniakbiar — Sat, 06 Sep 2014 19:15:58 GMT

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?

Re: Qlikview dynamic drill down -2 charts linked

israrkhan — Sat, 06 Sep 2014 19:48:11 GMT

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

Re: Qlikview dynamic drill down -2 charts linked

jiwaniakbiar — Sun, 07 Sep 2014 03:09:33 GMT

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?