topic Re: Hide row in pivot table in QlikView

Hide row in pivot table

AbhijitBansode — Wed, 13 Jul 2011 09:51:21 GMT

Hi, i have an requirement of hiding last row of pivot table.

anyone has idea?

martin59 — Wed, 13 Jul 2011 13:39:37 GMT

Hi,

Why do you want to hide the last row ? Is it a total ?

AbhijitBansode — Wed, 13 Jul 2011 13:44:51 GMT

It is not the total..

last row is there in pivot table with some values..

but i dont want to show this row...

martin59 — Wed, 13 Jul 2011 13:48:04 GMT

Can you delete thoses datas in your load script or they're useful ?

AbhijitBansode — Wed, 13 Jul 2011 14:00:44 GMT

No i cannot delete them..

I purposefully created this row for some other calculation requirement.

I only want to hide this row.

I can make its text color as White by checking if condition,but still blank row appears.

Please help me how can i hide the same or for workaround is it possible to make height of this column as zero using macro.

martin59 — Wed, 13 Jul 2011 14:04:30 GMT

Is this line has got particular values or something to found it and not the other rows ?

AbhijitBansode — Wed, 13 Jul 2011 14:08:10 GMT

Yes,

In this line Product will always have value as 'XX' . so we can easily figure out this line(row) by checking if(Prodcut='XX').

Wed, 13 Jul 2011 14:08:59 GMT

I had the same problem and have adjusted the color to the background with one condition.
Have you ever tried this?

Greetings Armin

martin59 — Wed, 13 Jul 2011 14:12:31 GMT

Right, you have to add the script below on each expression

{<Product-={XX}>}

Like this :

sum({<Product-={XX}>} Sales)

Hope that helps you

AbhijitBansode — Thu, 14 Jul 2011 04:13:39 GMT

I can not use above stated expression for sum, because it will filter records of table depending upon that condition.

i dont want to filter records , i only want to hide the row...

i have trieid setting background color of the same.. but still the blank row displays.

AbhijitBansode — Thu, 14 Jul 2011 14:44:37 GMT

Please find the attached excel file for details of the problem and sample qvw application .