Create dynamic columns

[macabrera]

Hi...

I would like to create new columns based on one measure.

Is I have this data

dim, value

A,    1

B,    2

C,    3

I want to see this on my table

A B C

1 2 3

But just using one measure sum(value)

[Taoufiq_Zarra]

@macabrera 

you can use three expressions, one for each dimension (A, B, C),

for example :

measure 1 : Sum({<dim={'A'}>} value)

label : A

same for B and C

attached qlik example

[macabrera]

Yes, that I know.. but I would like not to use diferent expressions, just one, and that the columns are generated even if I dont know the values of the dimension

[Taoufiq_Zarra]

@macabrera 

You can use Pivot table to generate automatically based on the dimension values, even if those values are not known in advance.

attached qlikview example same for qliksense

[macabrera]

thanks... but I need it to be a normal Table, Because I have other measures, that I dont want to be under the dimention ACB

like

Measure1, Measure2, MeasureA, MeasureB, MeasureC

(Without creating MeasureA, MeasureB, MeasureC as individual Measures)

[Taoufiq_Zarra]

you can use Edit table ?