Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 Month | Rolling Year | |||||||||
2016 | 2015 | 2014 | % Chg CY | % Change PY | 2016 | 2015 | 2014 | % 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% |
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.
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.
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.
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.