topic Recreating Excel Tables in Qlikview in QlikView

Recreating Excel Tables in Qlikview

Thu, 18 Feb 2016 17:57:25 GMT

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%

Re: Recreating Excel Tables in Qlikview

Anonymous — Thu, 18 Feb 2016 19:04:26 GMT

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.

Re: Recreating Excel Tables in Qlikview

Anonymous — Fri, 19 Feb 2016 05:29:19 GMT

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.

Re: Recreating Excel Tables in Qlikview

Fri, 19 Feb 2016 14:45:00 GMT

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.