Qlik Community

QlikView Documents

Documents for QlikView related information.

Expression Overview In Pivot Table

Employee
Employee

Expression Overview In Pivot Table

Have you ever used a text object to test your calculations?

I know I do it all the time. After a while I end up with these cryptic text object without any obvious meaning.

1.png

To make it more apparent an option is to add text to show the intention.

2.png

Often I find it more convenient to use a Pivot Table, with the expression I want to look at or play around with.

3.png

Now it is very easy to add, change and apply expressions and observe the results in a nice and tidy table form.

4.png

The only thing to keep in mind is that the chart in this shape does not have any dimensions, so all expressions will be processed as expression totals just like a text object.

Attachments
Version history
Revision #:
1 of 1
Last update:
‎06-09-2015 05:07 AM
Updated by:
Employee