Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bansefi01
New Contributor

KPI + SUM function to add multiple fields

I have multiple fields that need to be added in a KPI, how can this be solved ?

Sum ([Monto TP (punto fijo)],[Monto TP (punto temporal],[Monto TDD])

thanks

Tags (1)
4 Replies
MVP
MVP

Re: KPI + SUM function to add multiple fields

May be this

RangeSum(

Sum([Monto TP (punto fijo)]),

Sum([Monto TP (punto temporal]),

Sum([Monto TDD])

)

bansefi01
New Contributor

Re: KPI + SUM function to add multiple fields

thanks

bansefi01
New Contributor

Re: KPI + SUM function to add multiple fields

Thanks a lot, i used it and it works perfectly

Wondering, is there a way to have SUM function for diferent fields with same name begin?

something like this

RangeSum(

Sum( {$} [<="punto*">]

Expected result should be the sum for all data fields with the same "punto" begin string

Thanks

MVP
MVP

Re: KPI + SUM function to add multiple fields

You should be able to use The Crosstable Load and then convert your fields into a column then use set analysis to do this....