topic Re: Drill Down not working in QlikView

Drill Down not working

Wed, 15 Jul 2015 07:32:07 GMT

Hi,

i have a question,

I have create group dimension contain two expression, there are :

The first one is

=if(................<>'A' and ................<>'B', PLACE) ----> if 'field value' not A and B then show PLACE dimension.

The second one is

=if(................<>'A' and ................<>'B', NAME) ----> if 'field value' not A and B then show NAME dimension.

both PLACE and NAME will be grouped into one group dimension called PLACE_NAME dimension.

When i use PLACE_NAME dimension on my straight table, it can't be drilled. When i click the PLACE, it is not change to NAME dimension, Anybody knows how to solve this problem ?

Really appreciate your help.

Thanks

Re: Drill Down not working

Wed, 15 Jul 2015 07:38:23 GMT

Are Places and Names are hierarchically related? I mean a Place has some names under it? The data should be like Year -> Quarter -> Month or Category -> Sub Category -> Product etc. so that drill down/up works.

Regards,

KKR

Re: Drill Down not working

Wed, 15 Jul 2015 07:42:55 GMT

Hi Kran,

Yes Kran, Every PLACE has NAME lets say PLACE A. In PLACE A there will be more than one NAME.

But when i click Place A, it's not change to NAME dimension. Do you see any problem in my "IF Expression" ?

Because when i use another group dimension, the drill down works perfectly.

Another group dimension contain two expression like this:

=if(....................='A' or .....................='B', PLACE)

the second one is:

=if(....................='A' or .....................='B', NAME)

the difference only on (= sign) and (<> sign)

Thanks

Re: Drill Down not working

antoniotiman — Wed, 15 Jul 2015 07:58:14 GMT

Hi INdra,

use Cyclic Group instead

If You click in

You have same behavior of Drill Group

If You click in

You have List

Regards,

Antonio

Re: Drill Down not working

jagan — Wed, 15 Jul 2015 08:01:52 GMT

Hi Indra,

Create new fields in script with the conditions, and then use those fields in the Dimension Group then this will work. If you attach sample file it would be easier to analyse and provide the solution.

Regards,

jagan.

Re: Drill Down not working

Wed, 15 Jul 2015 08:02:32 GMT

Hi Antonio,

Thanks for your suggestion, but i need to use drill down group, because when i click PLACE A that has amount 1000 ,it will change to NAME dimension that has total amount 1000.

Thanks

Re: Drill Down not working

Wed, 15 Jul 2015 08:07:49 GMT

Hi Jagan,

Sorry, unfortunately i cant attach the sample file. But ii think the problem is on my expression. Are there any problem with my conditional expression ?

=if(................<>'A' and ................<>'B', PLACE)

Are there any syntax that can be used to define 'not like' beside <> sign?

Thanks

Re: Drill Down not working

Wed, 15 Jul 2015 08:10:18 GMT

I have created two drill-down groups with some sample data and the given expressions, they worked. Just a basic test, do you have NAMEs whose field value is not A and B under the PLACEs whose field value is not A and B.

And why you are using and condition? Though it worked for the data I have taken, It doesn't make sense for me.

Regards,

KKR

Re: Drill Down not working

Thu, 16 Jul 2015 04:15:59 GMT

Did you check the data and condition as per the above reply?

Regards,

KKR