Transpose a table

[ts3st1000]

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

My table in the database looks like this:

product	year	sales
product1	2014	10
product2	2014	20
product3	2014	30
product1	2015	110
product2	2015	120
product3	2015	130
product1	2016	210
product2	2016	220
product3	2016	230

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

product	2014	2015	2016
product1	10	110	210
product2	20	120	220
product3	30	130	230

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

Much appreciated.

Thanks and regards,

Ra

[OmarBenSalem]

create a pivot table:

a dimension : product

as colum: Year

as measure : sum(Sales)