topic Re: Calculation in Pivot Table and List box in QlikView

Calculation in Pivot Table and List box

Fri, 19 Sep 2014 10:35:50 GMT

Hi,

I am sharing the excel sheet and sample app in that i need

1) In list boxes every field should appear in UPPER CASE.

2) In the Selections box i need to have one more value as TOTAL with summing up the values of "DUAL PACK, MULTI PACK and SINGLE" ( List box should appear with 4 values exsting 3 and TOTAL)

3) In the pivot table I need to have TOTAL filed which shows the sum of three other fields and as the other column with DUAL PACK+ MULTI pACK data as DUAL

can some kindly provide me the suggestions on this

i was experiencing the different results as i am performing the set analysis.

Re: Calculation in Pivot Table and List box

MK_QSL — Fri, 19 Sep 2014 10:39:47 GMT

1) UPPER(MODELS)

or better to change in the script itself..

UPPER(MODELS) as MODELS,

Try this in your script...

T1:

LOAD UPPER(SECTIONS) as SECTIONS,

UPPER(MODELS) as MODELS,

VALUES

FROM

DATA.xls

(biff, embedded labels, table is [Sheet1$]);

join

Load 'TOTAL' as MODELS, SUM(VALUES) as VALUES Resident T1;

Re: Calculation in Pivot Table and List box

Fri, 19 Sep 2014 10:46:20 GMT

Sorry it does not meet my requirement

can you share the app win which you got the result

Re: Calculation in Pivot Table and List box

jyothish8807 — Fri, 19 Sep 2014 10:56:48 GMT

PFA

Regards

Re: Calculation in Pivot Table and List box

Fri, 19 Sep 2014 11:39:40 GMT

Hi Jyothish

thanks for reply

i need the Total value as sum of those 3

ex: 1 + 2+ 3 as 6 i need it in seperate in column

and also i need total as 4tth value in list box as well

Re: Calculation in Pivot Table and List box

Fri, 19 Sep 2014 14:23:19 GMT

Suggestion required

Re: Re: Calculation in Pivot Table and List box

ecolomer — Fri, 19 Sep 2014 14:39:00 GMT

Is this you need?

DATA:

LOAD

Upper(SECTIONS) as SECTIONS,

Upper(MODELS) as MODELS,

VALUES

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Re: Calculation in Pivot Table and List box

ecolomer — Fri, 19 Sep 2014 14:42:18 GMT

or this ...?

DATA:

LOAD

Upper(SECTIONS) as SECTIONS,

Upper(MODELS) as MODELS,

VALUES

FROM

(ooxml, embedded labels, table is Sheet1);

join

Load

'TOTAL' as MODELS,

'TOTAL' as SECTIONS,

SUM(VALUES) as VALUES

Resident DATA;

Re: Re: Calculation in Pivot Table and List box

Fri, 19 Sep 2014 14:50:29 GMT

Almost

in the pivot table again I need multi pack + dual pack as a single column

Re: Calculation in Pivot Table and List box

Fri, 19 Sep 2014 14:52:50 GMT

In the pivot table I need multi pack + dual pack+ single as Total

and Mulit+ Dual as another column

Re: Re: Re: Calculation in Pivot Table and List box

ecolomer — Fri, 19 Sep 2014 15:00:07 GMT

here ...

Re: Re: Re: Calculation in Pivot Table and List box

ecolomer — Fri, 19 Sep 2014 15:00:43 GMT

see the last file upload

Re: Calculation in Pivot Table and List box

ecolomer — Fri, 19 Sep 2014 15:13:27 GMT

Re: Calculation in Pivot Table and List box

Fri, 19 Sep 2014 15:16:38 GMT

thanks

but the calculations are accurate

Re: Calculation in Pivot Table and List box

Anonymous — Fri, 19 Sep 2014 21:32:21 GMT

see attached.

Re: Re: Calculation in Pivot Table and List box

Anonymous — Mon, 22 Sep 2014 12:54:33 GMT

see attached.

shows only total and dual columns while using pivot table chart object.

glad to help.

Re: Calculation in Pivot Table and List box

Mon, 22 Sep 2014 13:24:02 GMT

Glad to receive your suggestion once again

cant we do generic load in straight table

can you provide me the sample or kindly have a look at this post

Straight table