Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cabhijit
Valued Contributor

Hide row in pivot table

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

anyone has idea?

10 Replies
martin59
Valued Contributor II

Hide row in pivot table

Hi,

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

cabhijit
Valued Contributor

Re: Hide row in pivot table

It is not the total..

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

but i dont want to show this row...

martin59
Valued Contributor II

Re: Hide row in pivot table

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

cabhijit
Valued Contributor

Re: Hide row in pivot table

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
Valued Contributor II

Re: Hide row in pivot table

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

cabhijit
Valued Contributor

Re: Hide row in pivot table

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').

Not applicable

Re: Hide row in pivot table

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

Greetings Armin

martin59
Valued Contributor II

Re: Hide row in pivot table

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

{<Product-={XX}>}

Like this :

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

Hope that helps you

cabhijit
Valued Contributor

Re: Hide row in pivot table

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.

Community Browser