topic Set Analysis in QlikView

Set Analysis

shumailh — Sun, 10 Jul 2011 07:56:54 GMT

below code is not working, anyone please help

=sum({$<MonthName_ID = {MonthName(MonthEnd(LoadDate-Day(LoadDate)))}>} bal)/(100*1000000)

nagaiank — Sun, 10 Jul 2011 12:58:13 GMT

Try the following:

=sum({$<MonthName_ID = {MonthName(LoadDate,-1)}>} bal)/(100*1000000)

Is the format of the fieldvalues in the MonthName_ID field the same as the format returned by MonthName function (i.e., Mmm YYYY)?

shumailh — Mon, 11 Jul 2011 05:20:18 GMT

Yes the format is same.

Also I did it like this and its working..

=sum({$<MonthName_ID = {'$(=MonthName(MonthEnd(LoadDate -Day(LoadDate))))'}>} bal)

Thanks,

Shumail