Create Pivot Table in Load Script

Anonymous — Fri, 11 Sep 2015 18:27:45 GMT

Hi QV Expert:

I'm trying to create a pivot table in the load script because I need to add other calculation in the front end. My source data is in chart 1. The processed table should look like chart 2, with columns…

Preferred (N)/ Preferred (Y): the count of sellers that are labeled N/Y in the Preferred column in chart 1.
% of Preferred: Preferred (Y)/(Preferred (Y)+Preferred (N))
Has Preferred?: Y if Preferred (Y)> 0

Can someone help with the script? I was using "if (Preferred= 'Y', Count ([Seller]),0) as 'Preferred (Y)'" for Preferred (Y), but it didn't seem to work…

Thanks!

chart 1

Item	Seller	Preferred Seller
Apple	Farm A	Y
Apple	Farm C	N
Orange	Farm C	N
Orange	Farm A	Y
Orange	Farm B	N
Pear	Farm B	N
Pear	Farm A	Y
Watermelon	Farm B	N
Watermelon	Farm D	N

Chart 2

Item	Preferred (N)	Preferred (Y)	% of Preferred	Has preferred?
Apple	1	1	50%	Y
Orange	2	1	33%	Y
Pear	1	1	50%	Y
Watermelon	2	0	0%	N

Re: Create Pivot Table in Load Script

sinanozdemir — Fri, 11 Sep 2015 19:05:28 GMT

Hi,

Here is my approach:

Here is the data model:

I am also attaching the qvw.

Hope this helps.

topic Create Pivot Table in Load Script in QlikView

Create Pivot Table in Load Script

Re: Create Pivot Table in Load Script