Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmpate0
Creator II
Creator II

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

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 

9 Replies
vikasmahajan

Give Title as you want  and  in expression type '=

HTH

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
aaron_ppmc
Partner - Contributor III
Partner - Contributor III

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

Best Regards,

Aaron

qlikmpate0
Creator II
Creator II
Author

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
Creator II
Creator II
Author

I have tried this but I still get the title.

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
raajaswin
Creator III
Creator III

Try adding

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

To every expression title.

I think it will work

qlikmpate0
Creator II
Creator II
Author

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
Creator II
Creator II
Author

No sorry doesn't work

qlikmpate0
Creator II
Creator II
Author

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.