getcurrentfield with calculated dimension name

Wed, 20 Oct 2010 08:35:55 GMT

Hi Guys.

I have a following situation

inside expression, calculation logic changed depends on selected field (one from the group)

here is script

= if(
getcurrentfield( PrCo_ML ) = 'Product',
( SUM(Cnt ) / SUM( total generalAggregate1) ),
if(
getcurrentfield( PrCo_ML ) = 'Company',
( SUM( by_Company_Cnt ) / SUM( total generalAggregate1) )
,0 )
)

Qlikview file translated in two languages thats why under PrCo_ML placed following

=$(vD_Product)

=$(vD_Company)

...

vD_Product contain this code ='Product_'&Language

=$(vD_Company) is the similar one.

When I try compare results of the getcurrentfield( PrCo_ML ) with field name it teturn false

When I simply output result to the label of chart result is =$(vD_Product)

is it possible to compare getcurrentfield( PrCo_ML ) and find equal result?

topic getcurrentfield with calculated dimension name in QlikView

getcurrentfield with calculated dimension name