Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
pooja821
Creator
Creator

Remove blank columns in pivot table in qliksense

I m getting a blank column in pivot table while working with qliksense.

How can I remove this blank column without effecting the data.?

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

good please close this thread .

Best

Chanty

View solution in original post

11 Replies
Chanty4u
MVP
MVP

could you share your expression?  or some sample example?

pooja821
Creator
Creator
Author

I haven't used any expression. While  making pivot table and adding dimensions, measures, I get blank columns with values in it.

Chanty4u
MVP
MVP

uncheck below option  in addon tab  or  in dimesion tab also uncheck null.PNG

pooja821
Creator
Creator
Author

yes!. it worked! Thanks A lot!

Chanty4u
MVP
MVP

good please close this thread .

Best

Chanty

pooja821
Creator
Creator
Author

Is it possible to apply formatting in qliksense, like bold, italics and all.?

Chanty4u
MVP
MVP

you can write in expressions like below

if(sum(Sales)>1000,'<b>').

pooja821
Creator
Creator
Author

what if I want to apply in Headers?

Chanty4u
MVP
MVP

that functionality is not available i believe ..you need to go by extension

branch.qlik.com