Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I need help with sum on qlikview

Hi community! i've been working on a way to show a dashboard on qv, but i'm having some problems with the data im using, so i need some help to get the results that i need.

I have this table, and i need to make a formula that ONLY sums one value for field "Pauta" so when i make a sum, i only get.

Pauta          Kg.Neto
252292        677,42

252293        290,8

Total           968,22

I hope that you can understand what im trying to do.

Thx!

1 Solution

Accepted Solutions
terezagr
Partner - Creator III
Partner - Creator III

Set Analysis: Sum({<[Yes/No]={'Yes'},Operador=>}(Kg.Neto))

View solution in original post

14 Replies
terezagr
Partner - Creator III
Partner - Creator III

Hi,

try Sum(Distinct(Pauta)) and Sum(Distinct([Kg. Neto]))

Not applicable
Author

Hi Tereza, i've tried your solution, but i got this i need to sum only one value for each field "pauta"

MarcoWedel

straight or pivot table

dimension: Pauta

expression: Sum(Distinct [Kg. Neto])

Not applicable
Author

Marco, thanks for your help, but that doesn't solve the problem, i've tried that before, but if there's 2 "pauta" with the same value on Kg.Neto, only one value Kg.neto is going to be considered. And with dimension, i need to show the dimension "operador" because that's the zone of the country that i want to show.

jzimolong
Creator II
Creator II

I don't see the value for "operador" in the table above, so it's touch to come up with a sample.

terezagr
Partner - Creator III
Partner - Creator III

See attached picture with exampleCapture.PNG

MarcoWedel

You have to explain your data model and expected result.

If Pauta is a dimension then two equal kg.neto values will be considered for their respective pauta values even if you sum only distinct kg.neto values.

Maybe someone more examples could help.

regards

Marco

Not applicable
Author

Ok, i'll try to explain with an example on excel.

So, what i have to show on the straight/pivot table its the sum of only unique valors like i show on the table to the right. I hope i've explained this well xD. Thanks!

(Pauta is not a dimension, only "Operador" is a dimension)

terezagr
Partner - Creator III
Partner - Creator III

Set Analysis: Sum({<[Yes/No]={'Yes'},Operador=>}(Kg.Neto))