topic Re: Hiding an expression in pivot table in QlikView

Hiding an expression in pivot table

triciagdaly — Wed, 14 Jan 2015 20:14:02 GMT

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.

Re: Hiding an expression in pivot table

Anonymous — Wed, 14 Jan 2015 20:22:15 GMT

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

and same expression header.

Re: Hiding an expression in pivot table

jduenyas — Wed, 14 Jan 2015 20:26:41 GMT

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

Re: Hiding an expression in pivot table

triciagdaly — Wed, 14 Jan 2015 20:28:09 GMT

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.

Re: Hiding an expression in pivot table

triciagdaly — Wed, 14 Jan 2015 20:30:23 GMT

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

Re: Hiding an expression in pivot table

Anonymous — Wed, 14 Jan 2015 20:31:08 GMT

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.

Re: Hiding an expression in pivot table

triciagdaly — Wed, 14 Jan 2015 20:36:08 GMT

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

Re: Hiding an expression in pivot table

Anonymous — Wed, 14 Jan 2015 20:40:20 GMT

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

Re: Hiding an expression in pivot table

triciagdaly — Wed, 14 Jan 2015 20:43:43 GMT

Oh sorry...

Re: Hiding an expression in pivot table

Anonymous — Wed, 14 Jan 2015 20:53:13 GMT

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.

Re: Hiding an expression in pivot table

jduenyas — Wed, 14 Jan 2015 21:06:03 GMT

Before unchecking

Unchecking

After unchecking

Re: Hiding an expression in pivot table

Anonymous — Wed, 14 Jan 2015 21:13:02 GMT

I assume that the Tricia's problem here that there is no label for the column "Amount" (?)

If there is only one expression, the column header is gone.

Re: Hiding an expression in pivot table

triciagdaly — Wed, 14 Jan 2015 21:19:00 GMT

Yes I have a label for Tons. Puzzled why it was removed when unchecking Enable.

Re: Hiding an expression in pivot table

triciagdaly — Wed, 14 Jan 2015 21:22:57 GMT

Attached is the qvw.

Re: Hiding an expression in pivot table

Anonymous — Wed, 14 Jan 2015 21:30:48 GMT

Sending back with two changes.

- Applied colors to the dummy expression

- Ran the macro (by pressing Test in macro editor)

Re: Hiding an expression in pivot table

Anonymous — Wed, 14 Jan 2015 21:33:04 GMT

One more idea - in my file, go to the chart properties, tab Style, and uncheck "Vertical Expression Cell Borders". Much cleaner look...

Re: Hiding an expression in pivot table

kamielrajaram — Wed, 14 Jan 2015 21:45:56 GMT

Hi Tricia,

Try this in you conditional expression. It achieves your desired result without unchecking the enable box.

if(sum(Tonnage)>=0,0,1)

Re: Hiding an expression in pivot table

triciagdaly — Wed, 14 Jan 2015 21:46:56 GMT

I'm new to macros. Where did you invoke the macro?

Re: Hiding an expression in pivot table

Anonymous — Wed, 14 Jan 2015 21:49:12 GMT

Clicked "Test" button (on the left) in the macro editor.

Re: Hiding an expression in pivot table

triciagdaly — Wed, 14 Jan 2015 22:16:34 GMT

Kamiel,

Thank you. However, This produces the same result as unchecking enable box. Michael's suggestion is working.