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: 
gegregeal
Partner - Contributor II
Partner - Contributor II

Need help with expression in set analysis

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,

Labels (1)
1 Solution

Accepted Solutions
gegregeal
Partner - Contributor II
Partner - Contributor II
Author

Thanks Experts,

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

Thanks

View solution in original post

4 Replies
gegregeal
Partner - Contributor II
Partner - Contributor II
Author

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.

gegregeal
Partner - Contributor II
Partner - Contributor II
Author

Thanks Experts,

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

Thanks