Adding additional columns on a pivot table without a dimension

eliran — Sun, 13 Feb 2011 11:08:45 GMT

Hey,

I have a Pivot table that gets the information from 3 different tables; Sales, WP, RFC.

The Pivot holds 3 fields; Qty, Value, Avg P.

Instead of writing 9 expressions I made a dimension ('Source') that holds Sales,WP & RFC as values.

This way I wrote only 3 expressions with if statements and used the 'Source' as a dimension.

So now I have a nice looking pivot, the problem is, I need additional data that doesn't belong to the Source dimension.

For example, I need the delta between LY and RFC.

Any thoughts about how I can accomplish that ?

Regards,

Eliran.

Adding additional columns on a pivot table without a dimension

Sun, 13 Feb 2011 17:31:34 GMT

There are a bunch of different ways to apprach this. Without knowing all the details, I would try the simplest thing. You can refer to the other columns in a pivot by their expression label, just like script variables.

topic Adding additional columns on a pivot table without a dimension in QlikView

Adding additional columns on a pivot table without a dimension

Adding additional columns on a pivot table without a dimension