Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sculptorlv
Contributor II

How to concatinate

Hello again!

Please help to find adequate function. I need to do a concatenate in my Chart table.

I have two columns: a and b with the values ..

I need to get expression like this:

= 'a + b' = Text(a) + ' + ' Text(b) + ' = ' + Text(a +b)

Which function I have to use instead of Text and how can I make concatenation?

Thank you in advance.

1 Solution

Accepted Solutions
MVP
MVP

Re: How to concatinate

I think what if you try just this:

a & ' + ' & b

where & is used to concatenate here

7 Replies
MVP
MVP

Re: How to concatinate

I think what if you try just this:

a & ' + ' & b

where & is used to concatenate here

awhitfield
Esteemed Contributor

Re: How to concatinate

Hi,

Check out string functions in the QV Help File.

HTH

Andy

sculptorlv
Contributor II

Re: How to concatinate

Can you please tell me also, how to make Number format to x.xx and to x (integer)?


1.jpg


Thanks in advance!

MVP
MVP

Re: How to concatinate

Try Num() or Round function:

=Num(NumberField, '#,##0')

or

=Round(NumberField)

UPDATE: This number seems to be within a text? Is this the field where you are concatenating bunch of fields?

sculptorlv
Contributor II

Re: How to concatinate

These are evaluated values .. like

sum(IF(InMonth(Bouth__PostingDate,Today(),-3),Bouth_Cofee_Item_Money,0))

MVP
MVP

Re: How to concatinate

Then this:

Num(Sum(If(InMonth(Bouth__PostingDate,Today(),-3),Bouth_Cofee_Item_Money,0)), '#,##0')

or

Round(Sum(If(InMonth(Bouth__PostingDate,Today(),-3),Bouth_Cofee_Item_Money,0)))

sculptorlv
Contributor II

Re: How to concatinate

Thank.

That works perfect.

Community Browser