Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ts3st1000
New 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
Esteemed Contributor

Re: Transpose a table

create a pivot table:

a dimension : product

as colum: Year

as measure : sum(Sales)

Capture.PNG

Community Browser