Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Re: sum in pivot table

Change the expression adding "Month"

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

9 Replies
Highlighted
Specialist
Specialist

Wow..

Its working,

Thanks Fabio.

Shaila

Highlighted
Specialist
Specialist

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.

Highlighted
Specialist
Specialist

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

Highlighted
Specialist
Specialist

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

Highlighted
Partner
Partner

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

Highlighted
Specialist
Specialist

No effect,

Result is same, sale column appears twice.

Highlighted
Partner
Partner

Sorry. I understood what you need now.

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

Highlighted
Specialist
Specialist

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>

Highlighted
Partner
Partner

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.