topic Re: CurrentMonthSales in QlikView

CurrentMonthSales

vanderson009 — Sat, 19 Apr 2014 08:42:03 GMT

Hello Community,

I am using this expression to retrive current month sales

=sum({<MonthNameField={'=$(vMaxMonthName)'}>}sale)

my MonthNameField contains MonthName Data and current Data is Jan-14

my variable vMaxMonthName is also store Jan-14

but still i am unable to calculate Current Month Sales

Please need help.

- Thanks and Regards,

Villyee

swuehl — Sat, 19 Apr 2014 08:49:22 GMT

Try like

=sum({<MonthNameField={'$(vMaxMonthName)'}>}sale)

(removing the equal sign)

You want to just replace the variable with the text, no evaluation needed here.

MK_QSL — Sat, 19 Apr 2014 11:07:32 GMT

=sum({<MonthNameField={'$(=vMaxMonthName)'}>}sale)

=sum({<MonthNameField={'$(vMaxMonthName)'}>}sale)

=sum({<MonthNameField={'$(=Max(MonthNameField))'}>}sale)

kushalthakral — Sat, 19 Apr 2014 11:12:05 GMT

or in simple words try like this

sum(if(MonthNameField=$(vMaxMonthName),sale))

its_anandrjs — Sat, 19 Apr 2014 11:21:29 GMT

In very simple way you can write

=sum({<MonthNameField={'$(=Max(MonthNameField))'}>}sale)

=sum({<MonthNameField={"$(=Max(MonthNameField))"}>}sale)

And if you use variable

=sum({<MonthNameField={'$(vMaxMonthName)'}>} sale)

=sum({<MonthNameField={"$(vMaxMonthName)"}>} sale)