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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Expression in Pivot Table

Hi Everyone,

Capture.JPG

I wish to achieve something depicted in the above picture.

The dimension on the left can be removed/added based on user selection through dynamic table field selection, so Dimensionality will keep changing.

I am facing issue in introducing the Achievement column highlighted in yellow. Achievment = Sales of 12 months/Goals of 12 months.

Can I insert an expression like this in pivot table? If I use a straight table, I cannot have pivoted headers for sales and goals.

Please help.

gwassenaar

0 Replies