topic Hide an Expression in Pivot table in QlikView

Hide an Expression in Pivot table

Anonymous — Thu, 07 Jan 2016 17:14:27 GMT

Hello!

I have two expressions in pivot table. I am using the first expression(name) to derive the second expression...Thus, I have to enable it..

I just want to hide it and leave only the 2nd expression to show that depends on the on the 1st expression.

I tried using a conditional false()... it worked but the 2nd expression got affected. This table will be sent out to our customers and it's not good for for them to see 2 expressions in 1 dimension when they don't need the 1st. If it's not possible to hide an expression in the pivot table as stated in the community, how can I at least delete the 1st expression during Nprinting.

Pls. advice.

Rgds

Re: Hide an Expression in Pivot table

sacosta5 — Thu, 07 Jan 2016 18:56:19 GMT

Hi...

try disable the first expression.

Re: Hide an Expression in Pivot table

Anonymous — Thu, 07 Jan 2016 19:00:39 GMT

Have you tried creating a variable made of the first expression and using that same variable in the calculation for the second expression?

Re: Hide an Expression in Pivot table

Anonymous — Thu, 07 Jan 2016 20:01:13 GMT

Hi! Silvia,

I already tried to uncheck the enable to no avail... this will affect my 2nd expression.

Thanks for your time.

Re: Hide an Expression in Pivot table

Anonymous — Thu, 07 Jan 2016 20:08:44 GMT

A dodgy frig you could try :

Set the expression Display Options | Representation to Image
<Tick> Hide Text When Image Missing
Make the column as narrow as possible

Ain't got a clue what NPrinting will make of this though.

Re: Hide an Expression in Pivot table

Anonymous — Thu, 07 Jan 2016 20:35:00 GMT

Adding on to what Bill said, you could change the font color of the 1st expression to the same color as the background. Make the expression label one character ( a space bar ) and then make the column narrow.

I have done this several times to hide a column and I typically can get the column to be only a couple characters wide.

As for sending the chart to NPrinting. If you are sending an Image, this works great. I do this frequently. If you are recreating your pivot table in an Excel template in Nprinting, I have not tried that.

Hope that is Helpful

Re: Hide an Expression in Pivot table

jduenyas — Thu, 07 Jan 2016 20:40:54 GMT

Super nice trick!!!

Only set the label to a one empty string (space) or the whole formula will show in the header row.

Alternatively you can set the color of the Label text to the color of the background to make it "disappear"

Re: Hide an Expression in Pivot table

Anonymous — Thu, 07 Jan 2016 22:51:13 GMT

Hi! Mike,

I already hide the text by the text color and narrowed the 1st column...But it results 2 vertical lines...IF I uncheck the vertical expressions cell borders in the style, all vertical lines are gone which I don't want.

Thanks for your time...

Re: Hide an Expression in Pivot table

Anonymous — Thu, 07 Jan 2016 23:05:00 GMT

Two lines is what I get as well. I know it is not the optimal solution, but maybe you could shade the background of the hidden expression column to a shade that offers some contrast between your real expression columns. Just change your text font to the same color and it will be hidden. Almost as if you intended for there to be separation there.

Are you exporting images or data to Nprinting?

You marked your own answer as Helpful. Please mark mine Helpful if this has had any value for you.

Re: Hide an Expression in Pivot table

Anonymous — Thu, 07 Jan 2016 23:29:15 GMT

Hi! Mike,

I'm exporting data in Nprinting and email externally. That's why, I'm trying to get rid of the 1st column since it's no use to the report....This would be an issue if the recipient is trying to sum the the number for a no of weeks...The 1st column will be included on the 1st column...

Since hiding 1st column is quite impossible in Pivot table...My last hope is to paste as values when exporting data to nprinting and delete the first column...not sure iff macro is needed here.

Tks.

Re: Hide an Expression in Pivot table

Anonymous — Thu, 07 Jan 2016 23:37:58 GMT

Hi! David,

Not sure if I'm doing this right...but this is what I did ...

create a variable vPF

=RangeSum(Alt(Before(TOTAL ((vPF))), 0), sum({$<Category = {'Supply'}>} Qty) - sum({$<Category = {'Demand'}>} Qty))

Then,

delete the 1st expression and then change the formula on the 2nd expression...

=round((IF((vPF)>=0,0,-((vPF))))

The result is different...

Tks.

Re: Hide an Expression in Pivot table

Anonymous — Thu, 07 Jan 2016 23:42:25 GMT

I could not see the rest of your image above, so I don't know how many dimension are in your pivot table. So, you are saying that your data needs to be dynamic so that the end user can interact with it after you send it to them. Do you really need a pivot table? I have several straight table charts that act like stored procedures. You create an expression that you are going to hide. You then create an expression label for that. Then you create the next expression and use the label from the first in your expression. You can keep doing this until you get to your end result and then only display the net result column.

Re: Hide an Expression in Pivot table

Anonymous — Thu, 07 Jan 2016 23:59:01 GMT

Mike,

I have 9 dimensions and 2 of the them Week no and Mon week are converted into horizontal columns...This is why I can't use the straight table but pivot only... And you are correct, I need this dynamic so the user can interact.

Tks.