topic Re: Concatenating text and variables in QlikView

Concatenating text and variables

Tue, 22 Apr 2014 20:28:06 GMT

I store time or time stamp values (field TStamp) in a list box. In its title, I want to show the string "Count" followed by the value of count like this -

Count = 4760

I tried some code which did not work

- TimeStamp & =Count (TStamp)

- 'TimeStamp' & =Count (TStamp)

Please help me.

Re: Concatenating text and variables

its_anandrjs — Tue, 22 Apr 2014 20:30:10 GMT

Update please check now

Write like below and remove = sign from the Count statement

='TimeStamp '&Count (TStamp)

='TimeStamp ='& Count (TStamp)

Regards

Re: Concatenating text and variables

swuehl — Tue, 22 Apr 2014 20:32:11 GMT

='Count ' & count(TStamp)

Re: Concatenating text and variables

pgrenier — Tue, 22 Apr 2014 20:33:28 GMT

Hello John,

I invite you to try with the following:

='Count = ' & Count(TStamp)

Regards,

Philippe

Re: Concatenating text and variables

maxgro — Tue, 22 Apr 2014 20:47:08 GMT

='Count = ' & num(Count(TStamp), '#,##0')

Re: Concatenating text and variables

anbu1984 — Wed, 23 Apr 2014 07:24:49 GMT

Concat('Count = ',Count(TStamp))