How can I remove a title on a pivot table with no values

[qlikmpate0]

Hi,

I'm trying to nprint a pivot table, but I have a blank column which acts like a separator, defining the different brands as hightlighted in the attached.These columns are my separators.

Can some let me know how I can put that field as a separator? in nprinting or qlikview whichever is feasible.

Thanks in advance 

[vikasmahajan]

Give Title as you want  and  in expression type '=

HTH

Vikas

[aaron_ppmc]

fill in a space in the lable of your Expression, works for me.

Best Regards,

Aaron

[qlikmpate0]

I would like the title to display but only in the columns where there is a value. so the highlighted columns I want them to show a blank column. Hope that makes sense.

[qlikmpate0]

I have tried this but I still get the title.

[jonathandienst]

Try setting the column label to a space (not an empty string).

[raajaswin]

Try adding

if(isnull(Column_Name),'Null',Column_Name)

To every expression title.

I think it will work

[qlikmpate0]

I have tried that too because its a pivot table I think when exported to excel, I will always get a title although on the UI it will look perfect. I need some kind of formatting to say when exporting to excel to group the brand ie Tees1, Fleeces etc.

[qlikmpate0]

No sorry doesn't work

[qlikmpate0]

This does work frontend/UI, but when I export the tableto excel  I get the title in the excel spreadsheet which is meaningless, this is what I do not want.