Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to add totals to expression that has condition?


I have an expression with condition

=if([Division]='Electronics',if([Fiscal Quarter]='2013-4',sum([USD Product Bookings]),0),0)

The expression works fine but i am unable to add totals by using Presentation - Show Partial Sums

How do I add totals?

Thanks,

CD

1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Try this:

=Sum(if([Division]='Electronics',if([Fiscal Quarter]='2013-4',sum([USD Product Bookings]),0),0))

View solution in original post

1 Reply
Highlighted
Master II
Master II

Try this:

=Sum(if([Division]='Electronics',if([Fiscal Quarter]='2013-4',sum([USD Product Bookings]),0),0))

View solution in original post