Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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