topic Re: Passing drill down groups in expression in QlikView

Passing drill down groups in expression

rsdhavle — Mon, 20 Jan 2014 08:02:29 GMT

There is straight table chart and all dimensions are drill down groups. Suppose i have to add Calculated dimension which would be applicable on all these drill down groups what would be the best approach.

Re: Passing drill down groups in expression

jagan — Mon, 20 Jan 2014 08:51:38 GMT

Hi,

Can you come up with a sample app and example?

Regards,

Jagan.

Re: Passing drill down groups in expression

rsdhavle — Mon, 20 Jan 2014 09:04:25 GMT

Example:

In Straight table chart, Dimensions are as follows

Drill Group1

Drill Group2

Drill Group3

Drill Group4

Now in this same dimension tab i want to add one calculated dimension and in such a way that the condition should be applicable on all of the above drill down groups

Re: Re: Passing drill down groups in expression

Anonymous — Mon, 20 Jan 2014 09:31:14 GMT

Rohan

Have you looked at using the GetCurrentField() function ?

Below copied form the Help:

getcurrentfield (GroupName)

Returns the name of the currently active field in a group.

Example

getcurrentfield( myGroup )

Best Regards, Bill

Re: Passing drill down groups in expression

rsdhavle — Mon, 20 Jan 2014 09:54:09 GMT

Hi Bill,

Thanks but its not working for me. I am using it in the below expression:

((div(aggr(RowNo(),GetCurrentField(MyGroup),$(Variable4))+1)=$(Variable1) ,div(aggr(RowNo(),GetCurrentField(MyGroup)),$(Variable4))+1, null())

But it does not affect chart in any way.

Re: Passing drill down groups in expression

Anonymous — Mon, 20 Jan 2014 09:57:31 GMT

Rohan

The bracket at the beginning, after your if is red. Should it be removed ?

Best Regards, Bill

Re: Passing drill down groups in expression

rsdhavle — Mon, 20 Jan 2014 10:01:48 GMT

yup that should be removed