topic Re: How to make a Pivot Table like in this example? in QlikView

How to make a Pivot Table like in this example?

Wed, 25 Nov 2020 16:16:04 GMT

Please help me to make a Pivot Table like this one:

I believe it is a Pivot Table with groups. I've been reading in the community of any ideas how to make one like this but I can't find clear instructions.

I only have one dimension and one expression:

AREA	Sales
GMM East	6249006
GMM North	8756996
GMM South	10315633
GMM West	1415876

Thanks for the help!

Re: How to make a Pivot Table like in this example?

squeakie_pig — Tue, 19 Jul 2016 09:56:48 GMT

Depending on your data model, you could concatenate your dimension to be

GMM fieldname & ' ' &Direction fieldname

or create an expression for each

1.Sum({$<Fieldname1 ={'GMM'}, Fieldname2 ={'East'}>}Sales)

2. Sum({$<Fieldname1 ={'GMM'}, Fieldname2 ={'North'}>}Sales)

3. Sum({$<Fieldname1 ={'GMM'}, Fieldname2 ={'South'}>}Sales)

4. Sum({$<Fieldname1 ={'GMM'}, Fieldname2 ={'East'}>}Sales)

And have the expression name as GMM East

Re: How to make a Pivot Table like in this example?

sunny_talwar — Tue, 19 Jul 2016 09:58:37 GMT

Like this?

Script used:

Table:

LOAD *,

SubField(AREA, ' ', 1) as Field1,

SubField(AREA, ' ', 2) as Field3,

If(Match(SubField(AREA, ' ', 2), 'South', 'North'), 'Section 1', 'Section 2') as Field2

INLINE [

AREA, Sales

GMM East, 6249006

GMM North, 8756996

GMM South, 10315633

GMM West, 1415876

];

Re: How to make a Pivot Table like in this example?

Mark_Little — Tue, 19 Jul 2016 10:01:47 GMT

HI.

You would have to make the structure in Script.

Something Like Load

Data:

Load

Sales

LEFT(AREA,3) as GMM

SUBFIELD(AREA,' ' ,2) as Area

IF(SUBFIELD(AREA,' ' ,2) = 'South' OR SUBFIELD(AREA,' ' ,2) = 'North',

'Section 1',

'Section 2') as Section;

From YourData.

You then just add the individual fields to your Pivot.

Mark

Re: How to make a Pivot Table like in this example?

Tue, 19 Jul 2016 10:04:37 GMT

Hi,

You can create the required 3 fields from "AREA" in the script itself..