topic Re: sum in pivot table in QlikView

Re: sum in pivot table

fsimoes81 — Wed, 10 Dec 2014 17:07:41 GMT

Change the expression adding "Month"

Sum(TOTAL<[Store No_], Month>Payment)

Re: sum in pivot table

tyagishaila — Thu, 11 Dec 2014 03:37:56 GMT

Wow..

Its working,

Thanks Fabio.

Shaila

Re: sum in pivot table

tyagishaila — Thu, 11 Dec 2014 03:41:51 GMT

Could you solve my one more problem?

In place of Total in %, Can I show Sum in numbers?

means Sum(Payment),

Don't show sum(payment) 2 times (each for Loyality & NoLoyality),

Only show sum of( Loyality & NoLoyality) 1 time.

Re: sum in pivot table

tyagishaila — Thu, 11 Dec 2014 05:39:17 GMT

Could you solve my one more problem?

In place of Total in %, Can I show Sum in numbers?

means Sum(Payment),

Don't show sum(payment) 2 times (each for Loyality & NoLoyality),

Only show sum of( Loyality & NoLoyality) 1 time like

Loyality NoLoyality Total

Sum(%) Sum(%) Sum in numbers

Re: sum in pivot table

tyagishaila — Thu, 11 Dec 2014 05:41:15 GMT

Could you solve my one more problem?

In place of Total in %, Can I show Sum in numbers?

means Sum(Payment),

Don't show sum(payment) 2 times (each for Loyality & NoLoyality),

Only show sum of( Loyality & NoLoyality) 1 time like

Loyality NoLoyality Total

Sum(%) Sum(%) Sum in numbers

Re: sum in pivot table

fsimoes81 — Thu, 11 Dec 2014 15:54:48 GMT

Yes, move de expression at calculated dimension to script creating a new field

if([Loyalty Card No_]<>'','Loyality', 'Noloyality') as [Loyalty Card Type]

Then use that field on table

Re: sum in pivot table

tyagishaila — Fri, 12 Dec 2014 03:50:35 GMT

No effect,

Result is same, sale column appears twice.

Re: sum in pivot table

fsimoes81 — Fri, 12 Dec 2014 13:14:52 GMT

Sorry. I understood what you need now.

The bad news is, it's not possible to do with pivot table.

Re: Re: sum in pivot table

tyagishaila — Mon, 15 Dec 2014 04:32:57 GMT

Ohhh,

Then, What should I use, Is it possible in straight table?

On Fri, Dec 12, 2014 at 6:45 PM, Fábio Simões <qcwebmaster@qlikview.com>

Re: Re: sum in pivot table

fsimoes81 — Mon, 15 Dec 2014 11:12:00 GMT

Yes, using straight table, you can create your own colluns, format the Total columns. The problem is, you need to create all collumns one for month.