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: 
Not applicable

Recreating Excel Tables in Qlikview

How can I recreate this chart I have in Excel in Qlikview? I tried to make both Year and (Pending, New and Closed) as Dimensions in a straight table but I cannot get the Year to show horizontally and the Pending, New and Closed to show Vertically. Another issue I am having is that it is showing every Pending sum per year, when I want it totaled in my Expression value.     

Current MonthRolling Year
201620152014% Chg CY% Change PY201620152014% Chg CY% Chg PY
Pending       100,000          92,000          88,000 9%5% 100,000          92,000          88,000 9%5%
New           8,500            7,700            7,300 10%5% 102,000        101,200        100,800 1%0%
Closed           7,500            6,700            6,300 6%6% 100,800        101,000        100,200 1%1%
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

As Bill suggested, for this the Chart should be of type: Pivot Table. In the presentation Tab check "Allow Pivoting" as well as "Always Fully Expanded" . Then click on the Year header and drag it on top of the measure (you will see a blue line). Observe the attached image.

pivot1.png

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Use a Pivot Table and on the Presentation tab tick Always Fully Expanded.

Then drag and drop things to place them as rows / columns as per your needs.

Anonymous
Not applicable
Author

As Bill suggested, for this the Chart should be of type: Pivot Table. In the presentation Tab check "Allow Pivoting" as well as "Always Fully Expanded" . Then click on the Year header and drag it on top of the measure (you will see a blue line). Observe the attached image.

pivot1.png

Not applicable
Author

Thanks Nakul1001‌ and Bill .... I actually found another solution to this question. I created a Straight Table and used Set Analysis, which worked as well.