Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Not applicable

Urgent help please .. How to remove extra space?


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.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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

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]);

View solution in original post

14 Replies
Highlighted
Not applicable

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

in dimension

check supress null value

Highlighted
er_mohit
Honored Contributor II

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

Right click on chart Fit coloumn to Data

Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

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

Highlighted
MVP
MVP

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

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]);

View solution in original post

Highlighted
Not applicable

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

Can you share your app?

Highlighted
Partner
Partner

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

After Load statement put where clause

WHERE [From-to] <>' '

Hope this helps

Regards

Manideep

Highlighted
amit_saini
Honored Contributor III

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

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

Highlighted
Not applicable

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

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