Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Add expression vertically in pivot tables

I have a qlikview report which consist of 2 simple tables:

UnitID is the key to link both table.

I would like to have a analytic table which count the total sold unit by 2 dimension:

Agent & by Unit Layout. Add the bottom of the table, I would like to calculate the percentage of sales which is sold unit/Number of Unit Type and Available Unit (Number of Unit Type - Sold Unit)

Like the table below

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Re: Add expression vertically in pivot tables

Please check if the attached file works for you , please check the pivot on top

View solution in original post

4 Replies
Highlighted
Creator II
Creator II

Re: Add expression vertically in pivot tables

Not quite clear on the requirement...
Highlighted
Contributor
Contributor

Re: Add expression vertically in pivot tables

The table went missing. 

I would like to combined/joined the 3 table together become one like below:

JoinTable.jpg

Highlighted
Specialist II
Specialist II

Re: Add expression vertically in pivot tables

Please check if the attached file works for you , please check the pivot on top

View solution in original post

Highlighted
Contributor
Contributor

Re: Add expression vertically in pivot tables

To change the data to a vertical layout, drag the Values button in the Pivot Table Field List, from the Column Labels area to the Row Labels area. In most cases, the Values button should be positioned below the other fields in the Row Labels area. Official Site