topic AW:CONCAT PIVOT TABLE in QlikView

CONCAT PIVOT TABLE

Fri, 23 Jul 2010 15:58:02 GMT

Dear all,

I have a problem with a pivot table.

I want to add an Expression that is a concat of one field.

I want to do a concat on a expression that has to be a concat where a field called NUMORDER is the highest .

I'm using sentence:

CONCAT({$<[NUMORDEN]={'MAX([NUMORDEN])'}>}[DESIM])

But it doen't work. Can someone help me

Thanks a lot

brenner_martina — Fri, 23 Jul 2010 17:15:29 GMT

Hi,

Concat needs a sign to seperate fields, p.e.

CONCAT({$<[NUMORDEN]={'MAX([NUMORDEN])'}>}[DESIM], ', ')

Fri, 23 Jul 2010 17:21:49 GMT

ON expression it returns '' and there is data,

and on dimension it returns error on dimension.

Best regards