Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

surajap123
Contributor II

label in pivot table

Hi Experts,

In the pivot table, the 'expression label' doesn't appear when a single value is selected from the Measure listbox.
If more than 1 measure is selected then everything looks good.

How to enable the expression label when one measure is selected.

Thanks!

1 Solution

Accepted Solutions

Re: label in pivot table

Hi Suraj, when you have a vertical dimension and only one expression the default behaviour is hide the column labels, you can try using a calculated dimension for year like:

=Aggr(Dual(If(Count(DISTINCT Measure)>1, Year, Year & ' - ' & Measure), Year), Year)

View solution in original post

7 Replies

Re: label in pivot table

You may Demote ID to the last

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: label in pivot table

Hi Suraj, when you have a vertical dimension and only one expression the default behaviour is hide the column labels, you can try using a calculated dimension for year like:

=Aggr(Dual(If(Count(DISTINCT Measure)>1, Year, Year & ' - ' & Measure), Year), Year)

View solution in original post

gajapathy74
Contributor II

Re: label in pivot table

Hi,

It might be per design, if I bring the Year next to the ID (dimension) its showing the label when there is single Measure selection.

Please refer the attachment.

Re: label in pivot table

Hi Gajapathy, that's because you're not using any vertical dimension, the year dimension is transformed in a horizontal dimension.

The original document has 2 columns, one for each year, set as vertical dimension, I tried to keep the original vertical dimension.

cheburashka
Contributor III

Re: label in pivot table

Hi Guys,

Should you be interested in an improved version of the AdHoc report.

I've created a template qvw which contains an AdHoc table module.

It has all the best ideas about Adhoc reporting which I could find on the QlikCommunity combined in one solution.

A short post about the AdHoc table can be found here. Though I recommend you to check out the free video on QlikViewModules.com

Have fun Qlik'n, Koen

Re: label in pivot table

Liked It, Can you re share the Link of QVW. Because, As you provide the link is not working

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
manoj217
Contributor III

Re: label in pivot table

please share the correct link