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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
reema_dangwal
Contributor
Contributor
‎2019-09-09 06:27 AM

Qliksense Pivot Table

Hi,

I have this monthly data that I need to display in a pivot table.

I am able to display Months as columns, however I need to display Total as a column  for all months except last month.

Say if I have data from Jan-Jul 2019, I need a total column  to average only Jan-Jun 2019, and then I need to show other columns for variance of total from July.

Please suggest how it can be achieved.

Attached is the data file.

Thanks

Labels (2)
Labels
QliksensePivotTable.xlsx
737 Views
0 Likes
0 Replies