topic Pivot Table in QlikView

Pivot Table

vsharma1 — Wed, 25 Nov 2020 16:16:04 GMT

Can we display like below in Pivot Table?

		YTD 2018	YTD 2019	MTD 18	MTD 19
Textile	Revenue	5000	8000	500	700
Food	Revenue	2000	3000	200	250
Transport	Revenue	1000	2000	300	450

Re: Pivot Table

Gysbert_Wassenaar — Sat, 25 May 2019 13:35:03 GMT

Yes.

Re: Pivot Table

vsharma1 — Sat, 25 May 2019 13:58:14 GMT

Sorry i cant open qvw

Can you attach code in text file or word doc with screenshots if possible please thanks

Re: Pivot Table

vsharma1 — Sat, 25 May 2019 13:59:00 GMT

Sorry i cannnot open qvw

Can you attach code in text file or word doc with screenshots if possible please thanks

Re: Pivot Table

vsharma1 — Mon, 27 May 2019 02:32:10 GMT

i cant open the qvw since i do not have the license version available

Re: Pivot Table

Gysbert_Wassenaar — Mon, 27 May 2019 12:12:42 GMT

Here's the load script:

SET ThousandSep='.'; SET DecimalSep=','; SET MoneyThousandSep='.'; SET MoneyDecimalSep=','; SET MoneyFormat='€ #.##0,00;€ -#.##0,00'; SET TimeFormat='h:mm:ss'; SET DateFormat='D-M-YYYY'; SET TimestampFormat='D-M-YYYY h:mm:ss[.fff]'; SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec'; SET DayNames='ma;di;wo;do;vr;za;zo'; SET LongMonthNames='januari;februari;maart;april;mei;juni;juli;augustus;september;oktober;november;december'; SET LongDayNames='maandag;dinsdag;woensdag;donderdag;vrijdag;zaterdag;zondag'; SET FirstWeekDay=0; SET BrokenWeeks=0; SET ReferenceDay=4; SET FirstMonthOfYear=1; SET CollationLocale='nl-NL'; LOAD * INLINE [ Product, Type , YTD 2018, YTD 2019, MTD 18, MTD 19 Textile, Revenue, 5000, 8000, 500, 700 Food, Revenue, 2000, 3000, 200, 250 Transport, Revenue, 1000, 2000, 300, 450 ];

Here's the screenshot:

The pivot table has two dimensions: Product and Type.

The pivot table has four expressions: Sum([YTD 2018]),Sum([YTD 2019]),Sum([MTD 18]) and Sum([MTD 19])

Re: Pivot Table

vsharma1 — Tue, 28 May 2019 00:29:32 GMT

Thanks, I will try your solution and let you know soon