topic Re: Month wise sum in QlikView

Month wise sum

janardhan — Mon, 08 Sep 2014 06:10:31 GMT

Hi Friends,

This is my expression: =sum({<BD_Year={'=$(vCurrentYear)'}>}Gross_Premium)

For above expression i am getting values like total sum for 2014. but i need upto this year current month total Gross_Premium.

Please help me

ajaykumar1 — Mon, 08 Sep 2014 06:18:09 GMT

Try like this;

=sum({<BD_Year={"<=$(=MAX(PERIOD))"}>}Gross_Premium)

In the PERIOD place use your datefield which indicates the upto current month.

Regards,

Ajay

ashfaq_haseeb — Mon, 08 Sep 2014 06:18:23 GMT

Hi,

You need to look at YTD amd MTD.

YTD Expression

=Sum({$<Datefield = {'>$(=Max((YearStart(Today())))) <=$(=Max(Today()))'}>} Sales)

=Sum({$<Datefield = {'>$(=Max((YearStart(Datefield)))) <=$(=Max(Today()))'}>} Sales)

MTD Expression

=Sum({$<Datefield = {'>=$(=Max((MonthStart(Today())))) <=$(=Max(Today()))'}>} Sales)

=Sum({$<Datefield = {'>=$(=Max((MonthStart(Datefield)))) <=$(=Max(Today()))'}>} Sales)

Regards

ASHFAQ

janardhan — Mon, 08 Sep 2014 07:27:16 GMT

Thanks Mohammed

ashfaq_haseeb — Mon, 08 Sep 2014 08:40:43 GMT

welcome

Regards

ASHFAQ

Nagaraju_KCS — Mon, 22 Sep 2014 17:49:56 GMT

Hi Mohammed,

Same expression how to write in Script level..