Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
I think what if you try just this:
a & ' + ' & b
where & is used to concatenate here
Check out string functions in the QV Help File.
Can you please tell me also, how to make Number format to x.xx and to x (integer)?
Thanks in advance!
Try Num() or Round function:
UPDATE: This number seems to be within a text? Is this the field where you are concatenating bunch of fields?
These are evaluated values .. like
That works perfect.