Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
annas349
Contributor II
Contributor II

Quotes in function

Good afternoon!
Whether there is a method in function concat in quotes to put quotes that they were displayed as separators?
the separator character must be ';' , bur if I write '';'' it does not work

Thanks!

1 Solution

Accepted Solutions
Anil_Babu_Samineni

I think, You want to call like

=Concat(FieldName, chr(39) & ',' & chr(39))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

9 Replies
Peter_Cammaert
Partner
Partner

Hmm, I'm not entirely sure I understand your question.

You want a Concat() function call to use a semicolon as value separator? What's wrong with using ';' ? Stuff like this example should work out of the box.

=Concat(DISTINCT [Product Category], ';')

Peter

kamalqlik
Partner
Partner

Can you please elaborate your question a more or explain the output you require.

Regards

Kamal

annas349
Contributor II
Contributor II
Author

I need not the result like this:

chair,book,

Quotes should be in the result of this function, if it is possible.

'chair','book'

More extended - i need to receive from unrelated table (it is necessary for the task) multiple values so i could assign them to an associated table - with concat on this moment i can assign just one value, i search for the solution of this problem.

Now the function is like:

SUM(<={'$(=Concat())')

where a - associated table

b- unrelated table

Thanks

annas349
Contributor II
Contributor II
Author

Thank you for answer, but i need the output like 'chair','book',

So if it is possible, i am trying to understand how can save quotes in the result


Yana

Peter_Cammaert
Partner
Partner

Like this?

=chr(39) & Concat(DISTINCT [Product Category], chr(39) & ',' & chr(39)) & chr(39)

Anil_Babu_Samineni

I think, You want to call like

=Concat(FieldName, chr(39) & ',' & chr(39))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Peter_Cammaert
Partner
Partner

Be careful. This solution has no first or last quote. Just those in the middle.

Anil_Babu_Samineni

This makes bit shorter..

=Concat(DISTINCT Chr(39) & Customer & chr(39), ',')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anil_Babu_Samineni

I've comment to u earlier like

=Concat(DISTINCT Chr(39) & Customer & chr(39), ',')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)