topic Re: Create dynamic columns in App Development

Create dynamic columns

macabrera — Mon, 21 Oct 2024 10:56:59 GMT

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)

Re: Create dynamic columns

Taoufiq_Zarra — Mon, 21 Oct 2024 11:32:45 GMT

@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

Re: Create dynamic columns

macabrera — Mon, 21 Oct 2024 11:36:24 GMT

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

Re: Create dynamic columns

Taoufiq_Zarra — Mon, 21 Oct 2024 11:51:52 GMT

@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

Re: Create dynamic columns

macabrera — Mon, 21 Oct 2024 12:14:38 GMT

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

Measure1, Measure2, MeasureA, MeasureB, MeasureC

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

Re: Create dynamic columns

Taoufiq_Zarra — Mon, 21 Oct 2024 13:22:25 GMT

you can use Edit table ?