topic Re: Alternate States and Drill-Down Groups in QlikView

Alternate States and Drill-Down Groups

Anonymous — Thu, 19 Jan 2012 00:15:00 GMT

Has anyone gotten this to work in QlikView 11?

I have some alternate states set up for comparison purposes and was hoping to use a drill-down chart that I'm using elsewhere in the same document.

* I copied the working drill-down chart into two new places and assigned each its own alternate state.

* No, they're new objects, not links!

No mas. When I attempt to make a selection and drill down, it simply doesn't drill down - I get a single bar.

Has anyone else gotten these two to work together, or might this be Yet Another QlikView Bug?

Thanks,

Kent

Alternate States and Drill-Down Groups

Wed, 29 Feb 2012 08:53:11 GMT

I'm having this same problem. The QlikView documentation on Alternate States makes it sound like they work very similarly to the "Detach" functionality, which specifically disallows drill-down groups, so I'm afraid this is a feature rather than a bug. Its not a very good feature in my opinion...

If anyone figures this out, please let me (us) know!!

Alternate States and Drill-Down Groups

cesaraccardi — Tue, 06 Mar 2012 17:43:48 GMT

Hi, I had the same problem. In my case I used the conditional enabling of the dimensions to simulate the drill down using basicly the GetSelectedCount function. I think this may not be the best solution but this might help you.

Regards,

Cesar

Alternate States and Drill-Down Groups

murozel76 — Fri, 25 May 2012 12:45:35 GMT

I experienced the very same problem here and found this discussion just by "googling".

In a nutshell, as far as I see there is no direct solution to this problem yet, right?

Perhaps we should expect this to be improved in the next version.

Regards,

Re: Alternate States and Drill-Down Groups

billbois — Mon, 16 Jul 2012 19:49:59 GMT

I'm guessing there's no solution to this yet. Has anyone confirmed it as a Version 11 bug?

I'll attach a sample file to demonstrate what's happening.

Thanks,

Bill

Re: Alternate States and Drill-Down Groups

Wed, 13 Feb 2013 12:39:03 GMT

have you heard any more on this? is it a bug? Will it be fixed?

Re: Alternate States and Drill-Down Groups

Wed, 13 Feb 2013 12:39:07 GMT

have you heard any more on this? is it a bug? Will it be fixed?

Re: Alternate States and Drill-Down Groups

billbois — Thu, 07 Mar 2013 15:52:24 GMT

Sorry, no, I haven't heard anything more. Anyone else?

Re: Alternate States and Drill-Down Groups

Tue, 14 Oct 2014 10:05:09 GMT

Hi,

Has any one found the solution of this problem because am also stuck at the same problem..

if any body came up with some solutions.. plz share.

Thanks in advance.

Re: Alternate States and Drill-Down Groups

Anonymous — Mon, 20 Oct 2014 20:49:54 GMT

Hi Poshkant,

I've marked Cesar's post above as "Helpful" because it does give one method to work around the problem, but to my knowledge the problem hasn't actually been fixed - You'll need the workaround.

Re: Alternate States and Drill-Down Groups

bhorneber — Thu, 04 Dec 2014 15:10:49 GMT

Hi all,

based on Cesar's answer I build a file using conditional dimensions (with function GetPossibleCount) and a text object with actions (to clear selections).

It's not a solution, but might help some people to build a workaround.

Benedikt

Re: Alternate States and Drill-Down Groups

Wed, 10 Dec 2014 13:44:56 GMT

This is working as expected/designed.

Groups(drill down/cyclic) are defined under Document Properties, which reflects the entire document with a default state, rather than a particular object with an alternate state.

This is a consequence of the fact the groups are defined globally for the entire document and not locally for a specific object, and the way alternate states is implemented. Alternate states only propagates to a specified object (i.e. not a global group).

Re: Alternate States and Drill-Down Groups

Anonymous — Wed, 10 Dec 2014 15:24:55 GMT

Daniel,

I can understand that it's working as "expected" because it sounds like Alternate States were an outgrowth of Detach. However, I sure hope it wasn't "designed" that way - There's already an awful lot of weird undocumented dependencies, quirks, and inconsistencies in QlikView that are the antithesis of good design.

Re: Alternate States and Drill-Down Groups

Fri, 03 Apr 2015 08:25:14 GMT

You apply the alternate state to a Set expression and not the sheet or an object on a sheet. Do this and drill down works as it should.

e.g SUM({yourAlternateState<your Set Expression>}your Variable)

Re: Alternate States and Drill-Down Groups

bhorneber — Mon, 06 Apr 2015 15:09:41 GMT

Hi John,

could you please provide a demo file (feel free to use my attached file from above)?

I tried, but cannot make your proposal work.

Re: Alternate States and Drill-Down Groups

Anonymous — Thu, 11 Jun 2015 08:43:43 GMT

Yes, agreed. this does work.

It's a bit of a mission though but it does work.

Re: Alternate States and Drill-Down Groups

Anonymous — Tue, 31 Jul 2018 12:16:09 GMT

Thank , this has helped

How would the condition statement "=if(GetPossibleCount(Country)=1,False(),True())" look

if i want to create a drill down to the 4th dimension e.g. Continent>Country>State>City ?

Regards

Re: Alternate States and Drill-Down Groups

Anonymous — Tue, 28 Aug 2018 21:12:25 GMT

hi Nhlanhla, i have the same problem as you do. I am curious did you find a solution? thanks

Re: Alternate States and Drill-Down Groups

Anonymous — Tue, 04 Sep 2018 08:28:55 GMT

HI Jinhua

In my case I wanted to drill down 4 levels. Province>Local_Market>Centre>Name.

Each level gets more specific.

The conditional statements I used for each level were as follows:

Province_NBA : =if(GetPossibleCount(PROVINCE_NBA)=1,False(),true())

Local_Market: =if(GetPossibleCount(PROVINCE_NBA)=1,True(),False())

Centre_NBA: =if(GetPossibleCount(LOCAL_MARKET)=1,True(),False())

AE_Name_NBA: =if(GetPossibleCount(CENTRE_NBA)=1,True(),False())

At each level the formula counts the level above it except for the first 2 levels. If you want your graph to drill down more than 2 levels you will have to use a line chart because bar graphs don't drill down more than 2 levels.

This is how my graph looks

First level: Province_NBA : =if(GetPossibleCount(PROVINCE_NBA)=1,False(),true())

Second level: Local_Market: =if(GetPossibleCount(PROVINCE_NBA)=1,True(),False())

Third level: Centre_NBA: =if(GetPossibleCount(LOCAL_MARKET)=1,True(),False())

Fourth level: AE_Name_NBA: =if(GetPossibleCount(CENTRE_NBA)=1,True(),False())

I hope this was helpful.