Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ts3st1000
Contributor
Contributor

Transpose a table

this might be easy and i am still new to qlik.

My table in the database looks like this:

 

productyearsales
product1201410
product2201420
product3201430
product12015110
product22015120
product32015130
product12016210
product22016220
product32016230

I am trying to use qlik sense to display data in the following format:

 

product     2014     2015       2016
product110110210
product220120220
product330130230

For each year column, i have tried =if(Year = '2014', Product, null()), but this is not working.

Much appreciated.

Thanks and regards,

Ra

1 Reply
OmarBenSalem

create a pivot table:

a dimension : product

as colum: Year

as measure : sum(Sales)

Capture.PNG