topic Re: Why does my pivot table label disappear when pivoting ? in QlikView

Why does my pivot table label disappear when pivoting ?

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a pivot table comprising a single dimension of Year-Month which has been pivoted to display horizontally. The expression is displayed as a percentage, like this...

However, you will notice the expression label doesn't display even though I have it set thus...

Any ideas why the label doesn't show ?

Re: Why does my pivot table label disappear when pivoting ?

Chanty4u — Sun, 13 Mar 2016 16:40:35 GMT

can u chnge the chart type nd chk once?

Re: Why does my pivot table label disappear when pivoting ?

Digvijay_Singh — Sun, 13 Mar 2016 16:40:51 GMT

Not sure but it looks like you have used custom format cell and made both text and bkground color same.

Re: Why does my pivot table label disappear when pivoting ?

sunny_talwar — Sun, 13 Mar 2016 16:45:48 GMT

Is it possible to share a sample?

Re: Why does my pivot table label disappear when pivoting ?

settu_periasamy — Sun, 13 Mar 2016 17:03:12 GMT

Hi,

That is normal behaviour of pivot table in qv with single expression.. may be you can one more dummy dimension and drag to top..

Re: Why does my pivot table label disappear when pivoting ?

Sun, 13 Mar 2016 17:17:32 GMT

Here are screen shots of:

1. The original pivot table sheet object.

2. The 'Custom Format Cell' dialog box of the expression label cell ('Attendance') with the white background.

3. The pivot table after it's been pivoted so that the dimension Month-Year appears horizontally.Why has the expression label final displayed with a grey background ?

Re: Why does my pivot table label disappear when pivoting ?

Gysbert_Wassenaar — Sun, 13 Mar 2016 17:18:20 GMT

My guess is that the pivot table is designed that way. If you only have one expression it doesn't really make sense to show and the dimension value and the expression label as headers for each column. You'd give the pivot table itself a caption label that explains what measure it shows. And that is where you see the label you give the expression (unless you disable the caption or give the caption itself a label).

Re: Why does my pivot table label disappear when pivoting ?

Sun, 13 Mar 2016 17:19:07 GMT

Hi,

Thanks for the advice. How do I create a dummy dimension ?

Re: Why does my pivot table label disappear when pivoting ?

Sun, 13 Mar 2016 17:21:11 GMT

I was trying to copy the same format for other objects on the sheet. For example, pivot tables with more than 1 dimension.

Thanks for your help

Re: Why does my pivot table label disappear when pivoting ?

swuehl — Sun, 13 Mar 2016 17:35:22 GMT

Maybe it's also an option to use a straight table with 'horizontal' option enabled on presentation tab instead of the pivot table. This should get you the expression label as requested.

Re: Why does my pivot table label disappear when pivoting ?

Chanty4u — Sun, 13 Mar 2016 17:37:02 GMT

create with empty space as dimension

Re: Why does my pivot table label disappear when pivoting ?

Sun, 13 Mar 2016 17:43:54 GMT

Thanks for that. It's not perfect but at least it displays the first expression label.

Re: Why does my pivot table label disappear when pivoting ?

Chanty4u — Sun, 13 Mar 2016 17:46:50 GMT

Hiding Dimensions in Pivot Table

Re: Why does my pivot table label disappear when pivoting ?

Sun, 13 Mar 2016 18:56:17 GMT

Ah yes. This is the best solution. This works. Thanks to everyone who contributed to my understanding.