Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Sum formula

Like adding 2 columns, hiding in the column "Month", the reference "Overhaul ', to bring me the percentage?

Sum columns [Maint.] = {'Planned'} <> [Mês] ('Overhaul') [TotalPrice)/Sum columns [Maint.] = {'Planned','Unplanned'} <> [Mês] ('Overhaul') [TotalPrice)/

teste1.JPG

1 Reply
vinieme12
Not applicable

Re: Sum formula

Try


=

Sum ( {<[Maint.] = {'Planned'} , [Mês]  -= {'Overhaul'}  >} [TotalPrice])

/

Sum ( {<[Maint.] = {'Unplanned','Planned'} , [Mês]  -= {'Overhaul'}  >} [TotalPrice])