topic Re: How to Hide Header Line in Pivot table? in QlikView

How to Hide Header Line in Pivot table?

Thu, 09 Oct 2014 03:56:15 GMT

Hi,

I am using Pivot table with 1 dimension and 1 expression. I want to hide all the value of dimension header but I want expression value as per dimension wise.

Example

Month | Jan | Feb | Mar

%Var | 10.0% | 12.0% | 10.0%

So here I want to hide month dimension and I want %var as it is.

Help me out.

Thanks

Ravi Balar.

Re: How to Hide Header Line in Pivot table?

jsingh71 — Thu, 09 Oct 2014 04:16:51 GMT

Hello Ravi,

I think you already know how to change the dimension name in chart. If you dont want to display the name then under Label Text Box enter blank(Press space bar once) and it will hide the dimension name in your chart.

--Jai

Re: How to Hide Header Line in Pivot table?

Anonymous — Thu, 09 Oct 2014 04:22:33 GMT

PFA,

HOPE this is the thing you require.................

Regards

NITIN

Re: How to Hide Header Line in Pivot table?

Thu, 09 Oct 2014 04:24:30 GMT

Hi JSingh,

That will hide only my dimension label I want to hide entire dimension but its effect should be there.

Re: How to Hide Header Line in Pivot table?

Thu, 09 Oct 2014 04:25:19 GMT

Dear Ravi,

It is not possible with Pivot Table but In straight table you can hide column(Dimension).

The only you can do is just go to dimension label and press a space bar.

Thanks & Regards

Prince Anand

Re: How to Hide Header Line in Pivot table?

Thu, 09 Oct 2014 04:28:27 GMT

Yes I got it but in straight table after hiding dimension it effect is disappeared So.

I want other data depend on that dimension but dimension should be hided.

Re: How to Hide Header Line in Pivot table?

Thu, 09 Oct 2014 04:34:21 GMT

Dear Ravi,

But in Pivot Table there is no any inbuilt functionality to hide dimension.

Thanks & Regards

Prince Anand

Re: How to Hide Header Line in Pivot table?

Thu, 09 Oct 2014 04:35:05 GMT

In this ,

How you have hide that file_name and its values?

Re: How to Hide Header Line in Pivot table?

PrashantSangle — Thu, 09 Oct 2014 04:35:36 GMT

Hi,

Can attached sample apps?

When you hide dimension in straight table its effect remain.

Check it again.

Regards,

Re: How to Hide Header Line in Pivot table?

jsingh71 — Thu, 09 Oct 2014 04:40:14 GMT

Do one thing add one text object on top of your dimension name. It will hide your dimension and effect remain as well.

Re: Re: How to Hide Header Line in Pivot table?

Thu, 09 Oct 2014 04:51:19 GMT

Dear Ravi,

Yes It is Possible.

Go to Expression Properties->Click on Expression->In Total Mode Optrion Click on No Total.

Thanks & Regards

Prince Anand