bansefi01
Contributor II
2017-08-18
11:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- qlik sense kpi
1,532 Views
4 Replies
sunny_talwar
MVP
2017-08-18
12:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
RangeSum(
Sum([Monto TP (punto fijo)]),
Sum([Monto TP (punto temporal]),
Sum([Monto TDD])
)
bansefi01
Contributor II
2017-09-08
10:40 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks
1,349 Views
bansefi01
Contributor II
2017-09-09
10:43 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
1,349 Views
sunny_talwar
MVP
2017-09-10
07:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You should be able to use The Crosstable Load and then convert your fields into a column then use set analysis to do this....