topic Re: Urgent help please .. How to remove extra space? in QlikView

Urgent help please .. How to remove extra space?

Wed, 12 Mar 2014 11:23:57 GMT

Hi,

i have pivot table. all is fine but at the top it is showing blank values count. How can i remove it. I tried supress null values but nothing works.

Thanks.

Re: Urgent help please .. How to remove extra space?

Wed, 12 Mar 2014 11:25:28 GMT

in dimension

check supress null value

Re: Urgent help please .. How to remove extra space?

er_mohit — Wed, 12 Mar 2014 11:26:49 GMT

Right click on chart Fit coloumn to Data

Re: Urgent help please .. How to remove extra space?

Wed, 12 Mar 2014 11:30:36 GMT

Thanks I did it earlier but it's not working. Any help please?

Re: Urgent help please .. How to remove extra space?

Wed, 12 Mar 2014 11:30:56 GMT

Thanks. It's not working. Any help please?

Re: Urgent help please .. How to remove extra space?

MK_QSL — Wed, 12 Mar 2014 11:31:31 GMT

From-To is having null values...

You can add below in Script

IF NOT ISNULL([From-To], [From-To]) as [From-To]

or at the end of the script....

Where NOT ISNULL([From-To]);

Re: Urgent help please .. How to remove extra space?

Wed, 12 Mar 2014 11:32:13 GMT

Can you share your app?

Re: Urgent help please .. How to remove extra space?

manideep78 — Wed, 12 Mar 2014 11:34:31 GMT

After Load statement put where clause

WHERE [From-to] <>' '

Hope this helps

Regards

Manideep

Re: Urgent help please .. How to remove extra space?

amit_saini — Wed, 12 Mar 2014 11:40:05 GMT

Hi Ameila ,

Have you tried "Suppress When the Value is Null" Option under Dimensions Tab ????

I know you have mentioned this option already in your post but same kind of option is present under Presentation Tab also I don't know which one you have already tried.

Thanks,
AS

Re: Urgent help please .. How to remove extra space?

Wed, 12 Mar 2014 11:45:46 GMT

Thanks.

Actually the columns from-To is alias column like below

What& ' To ' &Queue as [From-To],

So, how can I change this? Please help

Re: Urgent help please .. How to remove extra space?

maxgro — Wed, 12 Mar 2014 11:48:51 GMT

are the values nulls?

if not trim them or change to nulls

Re: Urgent help please .. How to remove extra space?

MK_QSL — Wed, 12 Mar 2014 11:52:02 GMT

If you can please share your file, it will be easy for everyone to answer rather than just guessing!

Re: Urgent help please .. How to remove extra space?

Wed, 12 Mar 2014 11:52:10 GMT

Thanks. I tried both but not working.

Re: Urgent help please .. How to remove extra space?

Wed, 12 Mar 2014 12:16:32 GMT

i think you have multiple dimension, firstly expand all dimension, then check that in any dimension must be show any value. and then remove this dimension and use this dimension in expression. After that select each dimension in dimension tab and check supress null value.

Re: Urgent help please .. How to remove extra space?

Wed, 12 Mar 2014 15:01:04 GMT

Thanks. In another application it is ok.