Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Maybe this will help you.
Assuming your drill down dimension is named DrillDim
=sum(total <$(=GetCurrentField(DrillDim))> sales)
Sorry ,GetCurrentField() function is not in Qlik sense
Oh, I see. Then you can use GetObjectField() or GetObjectDimension() instead.
Throwing error for me if i add <Getobjectdimension()> into expression.
Is there any way to do this ?
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.
This expression will calculate total excluding the dimension in the second column.
sum(total <[$(=GetObjectDimension(1))]>Sales)
See attached QVF file
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.