topic Re: RE:How to hide? in QlikView

RE:How to hide?

Chanty4u — Thu, 07 Jan 2016 11:59:30 GMT

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

Re: RE:How to hide?

Thu, 07 Jan 2016 12:01:22 GMT

Hi,

you need to use straight table.

there is an option to hide expression...

Re: RE:How to hide?

HirisH_V7 — Thu, 07 Jan 2016 12:06:26 GMT

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.

Make Back ground ,Font Color as white()

HTH,

Hirish

Re: RE:How to hide?

Chanty4u — Thu, 07 Jan 2016 12:19:54 GMT

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

is it possible?

Re: RE:How to hide?

HirisH_V7 — Thu, 07 Jan 2016 12:39:36 GMT

Hi ,

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

Then,

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

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

HTH,

Hirish

Re: RE:How to hide?

Chanty4u — Thu, 07 Jan 2016 12:50:27 GMT

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

Re: RE:How to hide?

HirisH_V7 — Thu, 07 Jan 2016 13:03:57 GMT

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

Re: RE:How to hide?

Chanty4u — Thu, 07 Jan 2016 13:10:44 GMT

yeah..hirish...

its hiding its ok..

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

Re: RE:How to hide?

Chanty4u — Thu, 07 Jan 2016 13:14:53 GMT

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

Re: RE:How to hide?

jonathandienst — Thu, 07 Jan 2016 13:18:02 GMT

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.

Re: RE:How to hide?

HirisH_V7 — Thu, 07 Jan 2016 13:21:38 GMT

Hi ,

I think if you want to see only dimension means , we can go for List box or else if we are having more than one expression then we can hide the particular expression . so that we can see values of other expressions with respect to the dimension.

Hope this helps,

Regards,

Hirish

Re: RE:How to hide?

sacosta5 — Thu, 07 Jan 2016 19:12:34 GMT

Hello....

You can´t hide an expression in a pivote table, but you can try replace it. Maybe it's helpful:

Re: RE:How to hide?

Chanty4u — Fri, 08 Jan 2016 04:49:21 GMT

Nice idea...but that empty cells are displyng na......user doesn't need that empty cells also.

Re: RE:How to hide?

rajeshforqlikvi — Fri, 08 Jan 2016 04:58:23 GMT

Better convert pivot to straight table other wise you need to use Ad hoc reporting

Re: RE:How to hide?

jagan — Fri, 08 Jan 2016 05:11:08 GMT

Hi,

It is not possible to hide the expression, if you hide the expression the chart will be empty. You can place a Text object over the column.

Regards,

jagan.

Re: RE:How to hide?

Chanty4u — Fri, 08 Jan 2016 05:15:40 GMT

thnx jagan..