How to display separate year as dimension

[geam1988]

Hello,

I have a report like this. Year is Dimension  and sales value, quantity and others are Expressions. Now i have only one Dimension and 20 expressions.

Now i want to add more dimension. with 2018 , i also want to see the value of 2017 as well as 2016. i want to see the report like this.

Sales Report
Year	2018	2017	2016
sales Value	100	110	120
Quantity	5	4	6

i have tried following,

What should i do ?

Best regards

kazi

[Aurelien_Martinez]

Hi,

Can you share one expression (Sales value for example)?

[sunny_talwar]

Why don't you use a pivot table with Year as your dimension

QlikView Pivot Tables

[geam1988]

Hallo Martinez,

Thanks for your quick reply. report is working properly. unfortunately i cannot delete this discussion.

sum(VBRP.NETWR_EFF / fabs(VBRK.KURRF) )

Thank

Kazi

[Anil_Babu_Samineni]

As far i understand you are using Straight table with Horizontal option. So, We need to create multi expressions for that like

2018 = Sum({<Year = {2018}>} Measure)

2017 = Sum({<Year = {2017}>} Measure)

2016 = Sum({<Year = {2016}>} Measure)

But, If you can convey them we can use Pivot table like Sunny said.