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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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