Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

getcurrentfield with calculated dimension name

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?

0 Replies