topic Quotes in function in QlikView

Quotes in function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Quotes in function

Peter_Cammaert — Thu, 11 Jan 2018 16:08:12 GMT

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

Re: Quotes in function

kamalqlik — Thu, 11 Jan 2018 16:14:43 GMT

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

Regards

Kamal

Re: Quotes in function

Anonymous — Thu, 11 Jan 2018 16:34:10 GMT

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

Re: Quotes in function

Anonymous — Thu, 11 Jan 2018 16:38:35 GMT

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

Re: Quotes in function

Peter_Cammaert — Thu, 11 Jan 2018 16:46:35 GMT

Like this?

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

Re: Quotes in function

Anil_Babu_Samineni — Thu, 11 Jan 2018 16:48:27 GMT

I think, You want to call like

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

Re: Quotes in function

Peter_Cammaert — Thu, 11 Jan 2018 16:57:42 GMT

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

Re: Quotes in function

Anil_Babu_Samineni — Thu, 11 Jan 2018 16:58:42 GMT

This makes bit shorter..

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

Re: Quotes in function

Anil_Babu_Samineni — Thu, 11 Jan 2018 16:59:09 GMT

I've comment to u earlier like

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