Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

new field

Hi Community,

i create a pivot table.

1 field: Fabio

2^ field: Mazzarelli

I wish to create a 3th field ... Fabio Mazzarelli

Is it possible and howto?

3 Replies

Re: new field

Calculated Dimension

1st Field & 2nd Field

MVP
MVP

Re: new field

Not sure if I understand, but may be this:

Field1 & ' ' & Field2

ogster1974
Honored Contributor II

Re: new field

ABsolutely.  In Sense you need to create a new dimension in master items and include it in your pivot table.  The syntax Sunny provided will work for this.

REgards

Andy‌