topic Hiding only first column from table in QlikView

Hiding only first column from table

Fri, 17 Jul 2015 09:07:26 GMT

Hello. I've got pivot table with weeks placed horizontally and I'd like to hide columns in the first week, but leave the rest.

I want to hide selected columns, but leave the rest.

Is it possible to use some kind of IF at conditional value?

I tried if (FABRIC_CW = -1, FALSE(), TRUE()), but it's not working.

qlikmsg4u — Fri, 17 Jul 2015 09:11:30 GMT

Create calculated dimension like

=If(FABRIC_CW <> -1,FABRIC_CW )

and check Suppress when value is Null

tresB — Fri, 17 Jul 2015 09:12:07 GMT

Try calculated dimension like:

If(FABRIC_CW <> -1, FABRIC_CW)

Then check 'supress when value is null' in the dmension tab itself.

alexandros17 — Fri, 17 Jul 2015 09:12:36 GMT

Try with (editing the dimension)

if (FABRIC_KW = -1, Null(), FABRIC_KW)

and also check the box "Suppress Null Values"

Let me know

Fri, 17 Jul 2015 09:22:51 GMT

Yes, it works, but not the way I need it to work.

I need to have values from FABRIC_CW = -1, because I use them in further calculations, I'd like to only hide it, but without removing the whole CW.