Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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
nakul1001
Creator II
Creator II

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
bill_markham
Champion III
Champion III

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.

nakul1001
Creator II
Creator II

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.