Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
create a pivot table:
a dimension : product
as colum: Year
as measure : sum(Sales)