Qlik Sense Table with Dimensions and Expressions

[profilejamesbond]

Hi,

I want to calculate the KPIs like below table in Qlik Sense. The calendar year stretched automatically in horizontal way as shown in the given below table. While I want to add the static text as a dimension description like availble here in each row "static KPI text 1", ..., etc, and then I want to write an expression for the sales of 2023, 2022, and 2021 for each row.

The expected output should be like this: 

Year	2023	2022	2021
static KPI text 1	calculate kpi	calculate kpi	calculate kpi
static KPI text 2	calculate kpi	calculate kpi	calculate kpi
static KPI text 3	calculate kpi	calculate kpi	calculate kpi
static KPI text 4	calculate kpi	calculate kpi	calculate kpi
static KPI text 5	calculate kpi	calculate kpi	calculate kpi
static KPI text 6	calculate kpi	calculate kpi	calculate kpi

Thanks

[profilejamesbond · Accepted solution]

Solution:

Step 1: Create a Pivot table

Step 2: Dimensions Row -> move Values here

Step 3: Measures Values -> Add your expressions or measures with proper label

Thanks

[Benoit_C]

Thanks @profilejamesbond for providing the solution.

Regards,

Benoit