Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
madhudinesh
Partner - Contributor II
Partner - Contributor II

Need help on Set Analysis

Hi All,

I have the field value as below in 'Column A'. While declaring the same in set analysis similar to below, we are not receiving correct results as ' used is considered as delimiter. please help how this can be handled

=Sum({<[Column A] = {'Mark's Studio'}>} Sales) (or) Sum({<[Column A] = {"Mark's Studio"}>} Sales) 

Column A

Mark's Studio

@sunny_talwar 

Labels (2)
1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can use different kind of 'quotes'. These should work:

Sum({<[Column A] = {"Mark's Studio"}>} Sales)

Sum({<[Column A] = {`Mark's Studio`}>} Sales)

Sum({<[Column A] = {[Mark's Studio]}>} Sales)

And I think two single quotes in Mark''s should work too: =Sum({<[Column A] = {'Mark''s Studio'}>} Sales) 


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

You can use different kind of 'quotes'. These should work:

Sum({<[Column A] = {"Mark's Studio"}>} Sales)

Sum({<[Column A] = {`Mark's Studio`}>} Sales)

Sum({<[Column A] = {[Mark's Studio]}>} Sales)

And I think two single quotes in Mark''s should work too: =Sum({<[Column A] = {'Mark''s Studio'}>} Sales) 


talk is cheap, supply exceeds demand
madhudinesh
Partner - Contributor II
Partner - Contributor II
Author

Thank you so much for the quick response. These options works 🙂