Hiding an expression in pivot table

[triciagdaly]

When hiding an expression 'Cost' in a pivot table using  the conditional function of false(), it's removing the display of the other expression 'tons' (see result attachment)  I'm not sure how to reformat the pivot table .  The goal is to achieve the display in the first screen shot (before modification) but to remove or hide Cost column. 

[Anonymous]

You mean keep the expression label even if you have only one expression?  Try add a dummy expression with definition
=' '

and same expression header.

[jduenyas]

To hide the column Cost, simply uncheck the Enable checkbox.

[triciagdaly]

No, I do not want the column 'Cost' to be displayed at all , including the header.  I don't want to delete it bc the user will probably request it displayed at a later date.  I do need 'tons' displayed.

[triciagdaly]

When unchecking 'enable', I get the same result as making it false.  see below

[Anonymous · Accepted solution]

This is what I thought.

Use three expressions - tons, cost, and additional "dummy" expression.  The third expression is only to keep the header for tons when cost is hidden.

[triciagdaly]

Is there any way to remove the white space for the dummy expression =''  ?  Why was it removing the tons header?

[Anonymous]

I don't see a picture - can you attach please?

[triciagdaly]

Oh sorry...

[Anonymous]

Almost there

Reduce this column to 0 by using macro: http://community.qlik.com/message/356780#356780

Or just make the column as narrow as possible and apply color rules same as for the other expression.