Sum Expression in QLikview

[dunnalahk123]

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

[neha_shirsath]

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

[dunnalahk123]

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