Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
prma7799
Honored Contributor III

Top 20 fields in backend script

Hi All,

I want create one field in back end anyone can give some ideas for the same .

=aggr(if( rank(((SUM({$<FiscalYear={$(=max(FiscalYear))}>}[Gross Sales ])

   -   SUM({$<FiscalYear={$(=max(FiscalYear))}>}[Sales Return ])

    -  fabs(SUM({$<[Is SRN]={0},  [GL Code]={"4000001"},

    FiscalYear={$(=max(FiscalYear))}>} [Credit Note ]))

     +  SUM({$<[GL Code]={"4000001"},

      FiscalYear={$(=max(FiscalYear))}>} [Debit Note ]))    /100000),4)<=12,Divi ), Divi )

Thanks in Advance

3 Replies

Re: Top 20 fields in backend script

This is very complex to create in back end. what is the purpose of doing it in back end?

prma7799
Honored Contributor III

Re: Top 20 fields in backend script

Yes. Your right.

Actually I want to create this field for Nprinting excel report for to create top 20 divi.

If i achieve this field in back end then i will create top 20 divi wise sales report  in excel and will distribute to them.

Thanks

MVP
MVP

Re: Top 20 fields in backend script

Hi,

This is very difficult to calculate in back end, if you are able to achieve this front end then why you are looking for backend?

Regards,

Jagan.

Community Browser