how to calculate the field in script level....?

[#1]

Hi All,

I am using the below expression in script level.But its not working what is the problem

I am calculating the Max month related data is store into current2015count field.

if(Created_date = date(max(Created_date),'MMM') ,[2015  Count 1],) as current2015count

[avinashelite]

Please check the attachment for the solution.

[#3]

please write the discussion in discussion window ....i am using personal edition...

please help me.

[avinashelite]

Try like this:

Test:

LOAD Name,

     subject,

     Date,

     [value Count],

     marks

FROM

[http://community.qlik.com/thread/154524]

(html, codepage is 1252, embedded labels, table is @1);

NoConcatenate

Result:

load

Name,

     subject,

     Date,

     [value Count],

     sum(marks) as marks

     Resident Test group by Name,

     subject,

     Date,

     [value Count];

    drop table Test;

[mukesh24]

Hi Subbu,

When u r using aggregation function in Backend scripting use group by clause.

Regards,
Mukesh Chaudhari