topic Re: sum gross in QlikView

sum gross

Wed, 25 Nov 2020 16:16:04 GMT

Hi!

this is the data is have :

(for every month and every sales manager, his gross)

and I would like to have an expression that shows the sum of current month total gross.

this works when I select the current month. but if I make no selection then the value is 0..

=sum(if(date(today(),'MMM')=(month_sales), gross,0))

thank you all

Anil_Babu_Samineni — Wed, 07 Sep 2016 15:48:47 GMT

Expected o/p?

effinty2112 — Wed, 07 Sep 2016 15:55:32 GMT

Hi Namma,

Try:

=sum({$<month_sales = {$(=Month(Today()))}>}gross)

Cheers

Andrew

sunny_talwar — Wed, 07 Sep 2016 17:32:16 GMT

I would suggest creating a MonthYear field in your script

LOAD DateField,

Date(MonthStart(DateField)) as MonthYear,

Month(DateField) as Month

FROM/Resident ...;

and then may be something like this:

=Sum({<MonthYear = {"$(=Date(MonthStart(Today())))"}>} gross)