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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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