Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajkumar
Creator
Creator

Drill dimension in measure total < dimension> group

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

Labels (1)
7 Replies
Vegar
MVP
MVP

Maybe this will help you.

Assuming your drill down dimension is named DrillDim

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

 

Rajkumar
Creator
Creator
Author

Sorry ,GetCurrentField() function is not in Qlik sense

Vegar
MVP
MVP

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

Rajkumar
Creator
Creator
Author

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

Is there any way to do this ?

Vegar
MVP
MVP

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

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

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

image.png

 

See attached QVF file

TM21
Contributor
Contributor

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.