topic Re: label in pivot table in QlikView

label in pivot table

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: label in pivot table

Anil_Babu_Samineni — Mon, 14 Nov 2016 15:45:12 GMT

You may Demote ID to the last

Re: label in pivot table

rubenmarin — Mon, 14 Nov 2016 15:54:01 GMT

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)

Re: label in pivot table

gajapathy74 — Mon, 14 Nov 2016 16:04:01 GMT

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

rubenmarin — Mon, 14 Nov 2016 17:04:59 GMT

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.

Re: label in pivot table

cheburashka — Sat, 27 May 2017 19:35:51 GMT

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

Anil_Babu_Samineni — Sun, 28 May 2017 03:38:33 GMT

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

Re: label in pivot table

manoj217 — Fri, 17 Aug 2018 12:28:27 GMT

please share the correct link