Pivot Table

Anonymous — Wed, 24 Feb 2016 08:28:40 GMT

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.

Re: Pivot Table

marcus_sommer — Wed, 24 Feb 2016 15:48:13 GMT

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

topic Pivot Table in QlikView

Pivot Table

Re: Pivot Table