Drill dimension in measure total < dimension> group

[Rajkumar]

Hi all,

I have a drill down dimension.Ex. Country,city,District , store

My measure is sum (total <dimension> sales )

Here how do i change the dimension value according to drill down.

Please help me..

[Vegar]

Maybe this will help you.

Assuming your drill down dimension is named DrillDim

=sum(total <$(=GetCurrentField(DrillDim))> sales)

[Rajkumar]

Sorry ,GetCurrentField() function is not in Qlik sense

[Vegar]

Oh, I see. Then you can use GetObjectField() or GetObjectDimension() instead.

[Rajkumar]

Throwing error for me if i add  <Getobjectdimension()> into expression.

Is there any way to do this ?

[Vegar]

You might need to add an index number to the function. Take a look at the qlik help pages.

If it still doesn't work then I think I have an example on my PC that I will have access to later tonight or tomorrow that I could post here. Please let me know.

[Vegar]

This expression will calculate total excluding the dimension in the second column.

sum(total <[$(=GetObjectDimension(1))]>Sales)

See attached QVF file

[TM21]

Hi,

In my case I just used the expression "sum(Total "field")"  without <dimension> to solve my problem. It automatically sum ignoring the actual dimension.