Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
chiranjivdas
New 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
ecolomer
Honored Contributor II

Re: How to add totals to expression that has condition?

Try this:

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

1 Reply
ecolomer
Honored Contributor II

Re: How to add totals to expression that has condition?

Try this:

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