Pivot table as in excel

[felcar2013]

Hi

i need to create a pivot table in qlikview with 2 dimensions as rows and 2 dimensions (with granularity) as columns. It is not possible to do it wiht the Chart options. I dragged and dropped already, but i cannot do that with two dimensions and besides, i get the dimension name as a column without data in it.

are there other options to create a pivot table like the ones in excel?

thanks

felipe

Header 1	Header 2	Header 3	Header 4	DIMENSION 3	DIMENSION 3	DIMENSION 4	DIMENSION 4
	DIMENSION 1	DIMENSION 2	Num Member (EXPRESSION)	MALE	FEMALE	GRANULARITY  4.1	GRANULARITY 4.2
	total	2009	VALUES	::...	.	..	..
..	total	2010
	online	2009
	online	2010
							VALUES

[montero91 · Accepted solution]

Hi Felcar.

If you want to make the sum or count, you must use the "group by". The basic operations between fields b*a, a+b, a-b, etc. They directly. but count (a) or sum (B) you need "group by" some dimension.

and the us without ' only [

Example:

Load

region

contact_Age,
if(contact_Age>=18,count(contact_Age)) as [18 - 29],

....

from Table 1

Group by region

;

or if you want only a switch ' 1 or 0 ' to after summing them

Example:

Load

region

contact_Age,
if(contact_Age>=18,1,0) as [18 - 29],

....

from Table 1;

[felcar2013]

Thanks for the answer, as i have many dimensions to group by, i did as you told me the first time, and finally it worked. I created the if statements per age group and then added the count([agegroup]) in the chart expression for every new created [ageGroup]

felipe

[felcar2013]

Thanks for the answer, as i have many dimensions to group by, i did as you told me the first time, and finally it worked. I created the if statements per age group and then added the count([agegroup]) in the chart expression for every new created [ageGroup]

felipe