Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hiding only first column from table

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.

cut.PNG

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.

4 Replies
qlikmsg4u
Specialist
Specialist

Create calculated dimension like

=If(FABRIC_CW <> -1,FABRIC_CW )

and check Suppress when value is Null

tresesco
MVP
MVP

Try calculated dimension like:

If(FABRIC_CW <> -1, FABRIC_CW)

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

alexandros17
Partner - Champion III
Partner - Champion III

Try with (editing the dimension)

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

and also check the box "Suppress Null Values"

Let me know

Not applicable
Author

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.