Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

View solution in original post

14 Replies
Highlighted
Partner
Partner

Hi,

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

Highlighted
Not applicable

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

Highlighted

straight or pivot table

dimension: Pauta

expression: Sum(Distinct [Kg. Neto])

Highlighted
Not applicable

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.

Highlighted
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.

Highlighted
Partner
Partner

See attached picture with exampleCapture.PNG

Highlighted

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

Highlighted
Not applicable

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)

Highlighted
Partner
Partner

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

View solution in original post