Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
macabrera
Contributor II
Contributor II

Create dynamic columns

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)

 

Labels (1)
5 Replies
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

Taoufiq_Zarra_0-1729510358577.png

 

attached qlik example

 

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
macabrera
Contributor II
Contributor II
Author

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

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
macabrera
Contributor II
Contributor II
Author

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 ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉