topic Re: space issues in pivot table in QlikView

space issues in pivot table

Wed, 16 Jul 2014 09:53:38 GMT

How to remove the extra spaces / extra column in pivot table

Can you guide me

do guide me soultion

alexandros17 — Wed, 16 Jul 2014 10:06:24 GMT

You have a dimension whose values are "Budget" and "Actuals", for that diomension check the box "Suppress when value is null"

Let me know

Anonymous — Wed, 16 Jul 2014 10:11:00 GMT

Hi,

Suppress dimension which contain Budget and Actual value.

amit_saini — Wed, 16 Jul 2014 10:12:29 GMT

Try Satyadev suggestion , it should work.

Thanks,
AS

Wed, 16 Jul 2014 10:13:07 GMT

Select the dimension and check the supress when value is null.....

Wed, 16 Jul 2014 10:18:56 GMT

This space comes if more than one dimension is there.Try to use one dimension and rest are as measures.

Wed, 16 Jul 2014 12:03:45 GMT

Thanks for your quick resposne.

It doesnow work and not removing extra spaces

male_carrasco — Wed, 16 Jul 2014 12:12:54 GMT

hi!

Check "Always axpanded"

Best Regards,

Ale.-

Wed, 16 Jul 2014 12:22:31 GMT

sry "Always expanded" option is also not yeilding results.

can anyone suggest me any further ideas.