Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?