Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
AbhijitBansode
Specialist
Specialist

Hide row in pivot table

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

anyone has idea?

10 Replies
martin59
Specialist II
Specialist II

Hi,

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

AbhijitBansode
Specialist
Specialist
Author

It is not the total..

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

but i dont want to show this row...

martin59
Specialist II
Specialist II

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

AbhijitBansode
Specialist
Specialist
Author

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
Specialist II
Specialist II

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

AbhijitBansode
Specialist
Specialist
Author

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

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

Greetings Armin

martin59
Specialist II
Specialist II

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

{<Product-={XX}>}

Like this :

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

Hope that helps you

AbhijitBansode
Specialist
Specialist
Author

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.