topic Re: Sum Expression in QLikview in QlikView

Sum Expression in QLikview

dunnalahk123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

can some one help me , how can I write sum of Numvalue for Distinct Customer ID

in below function , how can I add Distinct [Customer ID]

NUM(Sum({$<ScenarioLabel={'Actuals'}>}[NumValue]) ,'0.#;0.#' ))

Best Regards,

Hari

Re: Sum Expression in QLikview

Peter_Cammaert — Fri, 22 Jun 2018 09:50:13 GMT

As a standalone expression? How would you like to visualise the list of results when more than one distinct Customer is active?

In a QlikView object, just add Customer as a Dimension and your expression to a Straight table, and QlikView will present only one sum per distinct Customer ID.

Re: Sum Expression in QLikview

dunnalahk123 — Fri, 22 Jun 2018 09:56:33 GMT

Hi Peter,

In Chart table I have different KPI's where I have to use above expression. For rawdeatils yes I am using table box.

Best Regards,

Re: Sum Expression in QLikview

Peter_Cammaert — Fri, 22 Jun 2018 10:00:51 GMT

A table box doesn't accept expressions. You can only show (and format to a limited extnt) existing field values, nothing else.

In your Chart, is Customer ID a dimension? If not, then how do you want to present thje Sum() result when for example 100 distinct Cusotmer IDs are active?

Re: Sum Expression in QLikview

PrashantSangle — Fri, 22 Jun 2018 10:07:51 GMT

can you explain sample app??

provide little bit more information.

Re: Sum Expression in QLikview

dunnalahk123 — Fri, 22 Jun 2018 10:26:10 GMT

Hi All,

Thank you every one.

I got it.

below is what I wrote

=Sum(DISTINCT{$<[Task ID] >} [NumValue])

Best Regards,

Re: Sum Expression in QLikview

Peter_Cammaert — Fri, 22 Jun 2018 10:53:38 GMT

This expression won't sum two identical copies of NumValue. Is that what you want, instead of producing sums for Distinct Customer IDs? Your results will be wrong if you sum for example two different invoices for the same customer and for the same amount...

Re: Sum Expression in QLikview

dunnalahk123 — Fri, 22 Jun 2018 11:32:43 GMT

Hi Peter,

You are right, its not working as expected 😞

Best Regards,

Re: Sum Expression in QLikview

PrashantSangle — Fri, 22 Jun 2018 11:36:10 GMT

try below

sum(Aggr(Distinct Sum({$<ScenarioLabel={'Actuals'}>}[NumValue]) ,Customer_ID))

Regards

Re: Sum Expression in QLikview

dunnalahk123 — Fri, 22 Jun 2018 11:36:30 GMT

Basically I have 2 objects.

first object is having Numvalue , Task ID.

but when I join with second object in relationship with one to many.

Task ID is getting duplicated bec one task can have multiple subtasks.

but I write a calculation in my Chart expression I should write a expression where it should give me

sum value for Distinct Task ID's.

Best Regards,

Re: Sum Expression in QLikview

neha_shirsath — Fri, 22 Jun 2018 11:46:09 GMT

Take task Id in your Dimension & expression will be Sum(value) this will give you single task with Total value for that task.

This is what you want..Correct?

Or Can you give more info on table on which you are joining..

Regards,

Neha

Re: Sum Expression in QLikview

dunnalahk123 — Fri, 22 Jun 2018 13:49:01 GMT

HI,

I am attaching .QVW File in that I explained what I am getting and what I need.

could you help me please.

Thank You. ! ! !