Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE:How to hide?

hi all,

I have a pivot table with  one expression....

i need to hide dat expression...and in pivot table i need to show onlt dimension....wiithout select anything?

is this possible?

thanks in advance.

suresh

1 Solution

Accepted Solutions
HirisH_V7
Master
Master

Hi,

At  the expression tab select your expression and  can check the box 'Conditional' at the right top  and use 0 as the condition that will permanently hide that expression.


PFA .


Hope this helps,

Regards,

Hirish

HirisH
“Aspire to Inspire before we Expire!”

View solution in original post

15 Replies
Not applicable

Hi,

you need to use straight table.

there is an option to hide expression...

HirisH_V7
Master
Master

Hi,

I  think we cannot hide a pivot table expression directly. Fill colour of the first expression to white, set the label to  ' ' (space) and make it as narrow as possible to make it (almost) disappear.

On the Style tab, uncheck "Vertical Expression Cell Borders" to avoid the appearance of an empty cell.

or

Make Back ground ,Font Color as white()

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Chanty4u
MVP
MVP
Author

how to show only one column  as bold.......in table box?

is it possible?

HirisH_V7
Master
Master

Hi ,

Settings -> user desgin -> Always show design menu items

Then,

on table box -> right click -> custom format cell


table box format.PNG


we can change back ground color of header and rows too for a  particular column.

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Chanty4u
MVP
MVP
Author

thnx hirish..it wrks fine... but i need frst one...pivot table issue

HirisH_V7
Master
Master

Hi,

At  the expression tab select your expression and  can check the box 'Conditional' at the right top  and use 0 as the condition that will permanently hide that expression.


PFA .


Hope this helps,

Regards,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Chanty4u
MVP
MVP
Author

yeah..hirish...

its hiding its ok..

but the other dimension values are nt shwng anythng.....?

Chanty4u
MVP
MVP
Author

chk image   when use exp conditional...exprsng gng hide..but there is no data shwng...as i hve dimension vluesexp.png

jonathandienst
Partner - Champion III
Partner - Champion III

A pivot table can display without an expression to show only the dimensions (unlike a straight table). You do need to uncheck the "Suppress Zero-Values" in Chart Properties | Presentation.

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