topic Remove First Row From Pivot Table in QlikView

Remove First Row From Pivot Table

Wed, 29 Oct 2014 14:10:03 GMT

Hi,

I have a pivot table without any dimensions, and with a couple of expressions.

I want to remove the first row, where the dimensions labels would have been.

I know that in a straight table I can hide it, but for my needs, it must be a pivot table.

I've attached a .qvw with a simple example.

Thanks!

Edit: clarification: I do not wish to remove the row 'count of Index', I want to remove the one above it, where the dimensions labels would have been.

Re: Remove First Row From Pivot Table

sorrakis01 — Wed, 29 Oct 2014 14:12:47 GMT

Hi,

In conditional of the expresion write this count(index)>0

Regards

Re: Remove First Row From Pivot Table

Anonymous — Wed, 29 Oct 2014 14:22:53 GMT

Jordi,

You can use 'if' in expression or in conditional to hide the expression.

Morandi

Re: Remove First Row From Pivot Table

sorrakis01 — Wed, 29 Oct 2014 14:26:53 GMT

Hi,

i knowed I didn't create the discussion

Regards,

Re: Remove First Row From Pivot Table

Wed, 29 Oct 2014 14:30:17 GMT

Hi,

Sorry, I probably didn't explain right.

I want to remove the first row (the gray one).

I changed the image and added an arrow to emphasize which row i want to hide.

Thanks!

Re: Remove First Row From Pivot Table

simondachstr — Wed, 29 Oct 2014 14:33:17 GMT

Not really what you were looking for, but a good workaround if you're fine with removing the caption.

Re: Remove First Row From Pivot Table

sorrakis01 — Wed, 29 Oct 2014 14:34:53 GMT

Hi,

I think You can't do it in a pivot use a straight.

Regards,

Re: Remove First Row From Pivot Table

Wed, 29 Oct 2014 14:56:18 GMT

Yes, i'm fine without the caption, but how did you do it?

I presume you changed the 'Costume format cell' but I cant replicate the same look

Re: Remove First Row From Pivot Table

simondachstr — Wed, 29 Oct 2014 15:20:42 GMT

Set everything to transparent (also in the properties page), remove borders etc. etc.

Re: Remove First Row From Pivot Table

Greg_Williams — Wed, 29 Oct 2014 15:27:18 GMT

Few ideas:

1 - Consider removing Aggregation / Total in Properties > Expressions tab

2 - Reduce font size to 1 > make everything white > custom format cells needs to be turned on for this to be available in User Preferences > Design.

Regards,

Greg

Re: Remove First Row From Pivot Table

Kushal_Chawda — Wed, 29 Oct 2014 15:33:53 GMT

Why you want to remove 1st line? Is it due to zero?

If so you are taking wrong field name in your expression. Field name is Index while you are taking expression as count(index). Field names are case sensitive.

Re: Remove First Row From Pivot Table

Sun, 02 Nov 2014 09:11:55 GMT

Thanks.

I couldn't replicate it myself, so I just copied what you've uploaded.