Need help with expression in set analysis

[gegregeal]

Hi Experts,

I have an expression that I am trying to use in my set analysis but it is not working when I tried to convert the single quote to chr(39). This expression works directly in the front end but I like to make it a variable.

Could you please help with this? 

The expression is

(Sum(Distinct m_promo_mul) * Sum({$<cont_flag = {1} $(=if(Match(GetObjectDimension(0), 'Value', 'Life Stage'), ', [' & GetObjectDimension(0) & '] = {*}', ''))>} m_promo_sale_amt) + Sum(Distinct m_nonp_mul) * Sum({$<cont_flag = {1} $(=if(Match(GetObjectDimension(0), 'Value', 'Life Stage'), ', [' & GetObjectDimension(0) & '] = {*}', ''))>} m_nonpromo_sale_amt))
/
(Sum(Distinct m_promo_mul) * Sum({$<ty_flag = {1} $(=if(Match(GetObjectDimension(0), 'Value', 'Life Stage'), ', [' & GetObjectDimension(0) & '] = {*}', ''))>} Total m_promo_sale_amt) + Sum(Distinct m_nonp_mul) * Sum({$<ty_flag = {1} $(=if(Match(GetObjectDimension(0), 'Value', 'Life Stage'), ', [' & GetObjectDimension(0) & '] = {*}', ''))>} Total m_nonpromo_sale_amt))

Thanks,

[gegregeal]

My question is, does single quotes work in set analysis and if not, is it every single quote I need to change in this expression?

Thanks,

[Kushal_Chawda]

single quotes works in set analysis but it depends how you use it.

[jsteyn]

See the Set Analysis cheat sheet

https://community.qlik.com/t5/QlikView-Documents/QlikView-Set-Analysis-Cheat-Sheet/ta-p/1485282

[gegregeal · Accepted solution]

Thanks Experts,

I have decided no to use this expression in set analysis.

Thanks