Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
martin_hamilton
Creator
Creator

Convert column values to rows based on another column

Hi

I have the following data loading via script:

RoleApr-19May-19Jun-19
Analytics Engineer                 0.19                               0.14
Analytics Engineer                                  0.95                     
Analytics Engineer                 0.33                                      

I would like to make the column headers values within a column and retain the values against these thus creating the following table to use in charts:

RoleMonthAmount
Analytics EngineerApr-19       0.19
Analytics EngineerMay-19       0.95  
Analytics EngineerJun-19       0.14

How would I do this in a script?

Thanks

Martin

Labels (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can use the CrossTable prefix to transform the data:

CrossTable(Month, Amount)
LOAD * FROM ....source.....

talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

You can use the CrossTable prefix to transform the data:

CrossTable(Month, Amount)
LOAD * FROM ....source.....

talk is cheap, supply exceeds demand

View solution in original post

valnod_90
Contributor III
Contributor III

https://www.youtube.com/watch?v=xkBFyNys1LI

 

hope this could help you!

martin_hamilton
Creator
Creator

Many Thanks exactly what I was looking for.

amulya22
Contributor
Contributor

Hi,

I also have very similiar query. 

I have my data like this 

Skill                                           %Complete                   EMP ID

AI                                                  0 %                                      1

Programming                          50  %                                  2

Excel                                           100   %                              3

 

and this my desired table

AI                      Programming                       Excel                     EMP ID

0                            10%                                          20%                              1

30%                      40%                                        50%                                2

 

any help is much appreciated 

Im very new to qlik