topic Re: I need help with sum on qlikview in QlikView

I need help with sum on qlikview

Fri, 20 Nov 2020 18:02:30 GMT

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!

Re: I need help with sum on qlikview

terezagr — Fri, 09 Jan 2015 19:08:29 GMT

Hi,

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

Re: I need help with sum on qlikview

Fri, 09 Jan 2015 19:14:54 GMT

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

Re: I need help with sum on qlikview

MarcoWedel — Fri, 09 Jan 2015 19:25:00 GMT

straight or pivot table

dimension: Pauta

expression: Sum(Distinct [Kg. Neto])

Re: I need help with sum on qlikview

Fri, 09 Jan 2015 19:35:20 GMT

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.

Re: I need help with sum on qlikview

jzimolong — Fri, 09 Jan 2015 19:39:17 GMT

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

Re: I need help with sum on qlikview

terezagr — Fri, 09 Jan 2015 19:41:34 GMT

See attached picture with example

Re: I need help with sum on qlikview

MarcoWedel — Fri, 09 Jan 2015 19:46:44 GMT

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

Re: I need help with sum on qlikview

Fri, 09 Jan 2015 19:56:45 GMT

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)

Re: I need help with sum on qlikview

terezagr — Fri, 09 Jan 2015 20:12:18 GMT

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

Re: I need help with sum on qlikview

terezagr — Fri, 09 Jan 2015 20:16:45 GMT

Sorry, forgot to attach picture with data that I have used:

Re: I need help with sum on qlikview

Fri, 09 Jan 2015 20:19:19 GMT

I'm going to try that, thanks TerezaGr!

Re: I need help with sum on qlikview

terezagr — Fri, 09 Jan 2015 20:34:00 GMT

No problem! Happy to help.

Please let me know if it works for you!

Re: I need help with sum on qlikview

Mon, 19 Jan 2015 13:30:23 GMT

Thanks TerezaGr, that was the answer

I have a new question with QV, should i create a new topic or just ask in this one?

Re: I need help with sum on qlikview

terezagr — Mon, 19 Jan 2015 13:44:49 GMT

Open a new topic. That way people will reply to you faster.

Have a good day.