Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Is it possible to populate the grey space in this pivot table?

Pivot Picture.png

I cant think of a way to populate the box highlighted in red on this pivot table. I need to put some date information in there which exports when the XL button is pressed (which means I can't do a textbox over the top).

Is it possible to put something in there?

Tags (1)
4 Replies
oknotsen
Honored Contributor III

Re: Is it possible to populate the grey space in this pivot table?

Textbox is the only way I know of, but you are telling us you do not want that because of exporting to Xls.

Could you tell us why you want to export it to xls? Sometimes the answer is something that can be done in QlikView instead.

Alternatively, you could look into making an NPrinting report and doing it that way.

May you live in interesting times!
kkkumar82
Valued Contributor III

Re: Is it possible to populate the grey space in this pivot table?

Hi ,

No, I had a same experience in my project and my solution is make all the columns heading to this grey colors.

for doing that first of all

1. Click the Design grid option in the design tool bar which is next to paint brush.

2. right the chart and you will get the "custom format cell" ensure your self that "design grid is selected".

3. In the window select "background" and adjust the color to the grey color.

Thanks

Kiran Kumar

Not applicable

Re: Is it possible to populate the grey space in this pivot table?

It's so the user can do ad hoc reporting - so I can't reply on NPrint.

They just want the ability to have this exact report as shown above but populate the gray box with the date the report was created. 

Not applicable

Re: Is it possible to populate the grey space in this pivot table?

I think it is as I suspected - there is no inherent way to populate that area with information.