Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
elaineng
Contributor III
Contributor III

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

Labels (2)
1 Solution

Accepted Solutions
anushree1
Specialist II
Specialist II

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

View solution in original post

9 Replies
alex00321
Creator II
Creator II

Not quite clear on the requirement...
elaineng
Contributor III
Contributor III
Author

The table went missing. 

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

JoinTable.jpg

anushree1
Specialist II
Specialist II

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

nikkia1236
Contributor
Contributor

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

karryscar21
Contributor
Contributor

Tellthebell is a Sweepstakes Program for the customers of Taco Bell. No matter whether they have the purchase receipt with them or not. It is possible to enter the Tellthebell Sweepstakes.

Drakesmith21
Contributor
Contributor

There are several franchises of the restaurant across the nation thus making it the largest burger chains in the country in about 2,200 locations across 21 states as well as Guam. https://jacklistenssurvey.shop/ 

juanneumann72
Contributor
Contributor

YourTexasBenefits is the login portal for the Texas state benefit programs. Login to YourTexasBenefits.com gives access to the Your Texas Benefits portal for those who need to apply for SNAP food, health care, Support Services, and TANF Cash Help.

Drakesmith21
Contributor
Contributor

With the help of the WalgreensListens survey team, you could carry out the survey in a perfect manner. Once you are done with the survey, you will be asked to accept the rules of the game and that’s it!

https://walgreenslistensus.shop/ 

james46541
Contributor
Contributor

MONOPOLY Collect to Win Game Stamps: Collect to Win Game Stamps describe the name of a MONOPOLY street property, location, airport, highway or RMHC location that corresponds to a street property, location, airport, highway or RMHC location on the Game Board. A Participant must collect and combine all of the original Collect to Win Game Stamps of the same colour group (or, if applicable, all of the airport Collect to Win 23 Game Stamps or both highways or all of the RMHC Collect to Win locations) necessary to form a potential Winning Combination for a Collect to Win Prize. The Game Stamp numbers of the Collect to Win Game Stamps rare mcdonalds pieces that must be collected to form a potential Winning Combination for a Collect to Win Prize can be found on individual Collect to Win Game Stamps and in Rule 4.D. below. If a Participant collects all of the Collect to Win Game Stamps required to complete a Winning Combination, that Participant is the potential winner of the Prize identified on the applicable Collect to Win Game Stamps and, in Rule 4.D. of these Official Rules, subject to verification of the Collect to Win Game Stamps, of the potential Winning Combination and of the Participant’s compliance with these Official Rules. The Sponsor will not honour and is not responsible for any combination of Game Stamps that is incomplete or any purported game stamp(s) which is/are copies of any genuine, original Game Stamp.