Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot Table

Hello,

I am new to QlikView and I have some questions about the PivotTable:

- How can I add a Total row to my table for each column, not a new dimension?

- Can I remove the line of a dimension 1 ?

- How do I export a PDF with my selection QlikView sheet?

- Also, when I indicate lightred () as a parameter in a back plane dimension, I do not understand why certain rows or columns are not colored red.

Thank you in advance for your help.

Wishing you a good day,

Sébastien.

1 Reply
marcus_sommer

It's mostly not helpful to ask several different question at the same time - it's then rather not clear which are related and where is the problem.

1) Within the presentation tab on the top left you could choose to which dimension you display a total.

2) Which line should be removed?

3) With desktop client or IE plugin you could the sheet print per menu: file respectively menu and then print sheet. Per Ajax client isn't this possible - you could try to use print-function from browser and if this isn#T good enough you need to create a report within the application: Using QlikView’s Report Editor

4) If cells have no value (NULL) they won't be colored - this meant you will need to fill these NULL with real values - within the expressions or more recommended within the script - it's not always easy and needs some efforts but has various advantages like the ability to select these missing values or NULL's.

- Marcus