Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Modify only the label of the expression in a Pivot Table

Hello all,

I use an expression in a pivot table.

The result of the expression is displayed in the header of the pivot table. I like this displaying and I would like to keep it.

I would like to modify the label of the column with the expression.

But, when I try to modify the label automatically I lose the result of my expression which was displayed in the header of my table.

Please could you tell me if I can keep the displaying of my header on one side and on the other side to modify only the name of the column with the expression.

Below a screenshot to illustrate my pivot table:

 

Capture.PNG

Thank you in advance for your help.

 

 

Labels (2)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

You could put both within the label, like:

= 'MyLabel' & chr(10) & '=MyExpression'

If I need to supply some info over the used expression or to provide a bit more context I use usually the comment-area of the expression/dimension. This keeps the labels neatly and if a user want to know more he/she could hoover on the label to see this extra information.

- Marcus

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

You could put both within the label, like:

= 'MyLabel' & chr(10) & '=MyExpression'

If I need to supply some info over the used expression or to provide a bit more context I use usually the comment-area of the expression/dimension. This keeps the labels neatly and if a user want to know more he/she could hoover on the label to see this extra information.

- Marcus

View solution in original post

Highlighted
Creator II
Creator II

Hello @marcus_sommer ,

I tried your solution and this gives me the display expected.

Thanks a lot for your help!!