Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Pivot table row names and set analysis

Hi,

I have a pivot table which has year dimension as a column. I also have one row of values (growth), it has been calculated via set analysis. The outcome is:

                              2017          2018          2019
                             growth     growth     growth
empty                *value*     *value*     *value*

When I want it to be:

                    2017          2018          2019
growth    *value*     *value*     *value*

 

I can hide the growth header, but even if I drop the growth header out, on the left is still the empty space. I would like to have the text "growth" on the empty space. Is there a way via set analysis to give a "name" to my set analysis calculation so that would show on the empty space on the left? That way I could hide the growth header and it would be just fine. Or is it possible to somehow to move the header on the left and hide the empty space? I hope that someones understands what I am trying to explain. Thank You!

BR,

AJ

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Try adding a row dimension with 'growth' as expression and growth as label.

talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Try adding a row dimension with 'growth' as expression and growth as label.

talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Partner
Partner

That never come to my mind, but it worked! Thank you!

BR,
AJ