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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
eliran
Creator III
Creator III

Adding additional columns on a pivot table without a dimension

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.

1 Reply
Not applicable

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.