Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
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)
6 Replies
Vegar
Partner
Partner

Maybe this will help you.

Assuming your drill down dimension is named DrillDim

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

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Rajkumar
Creator
Creator
Author

Sorry ,GetCurrentField() function is not in Qlik sense

Vegar
Partner
Partner

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Rajkumar
Creator
Creator
Author

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

Is there any way to do this ?

Vegar
Partner
Partner

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.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Vegar
Partner
Partner

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

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

image.png

 

See attached QVF file

Plees ekskuse my Swenglish and or Norweglish spelling misstakes