topic Top 20 fields in backend script in QlikView

Top 20 fields in backend script

prma7799 — Thu, 01 Oct 2015 06:00:17 GMT

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

Kushal_Chawda — Thu, 01 Oct 2015 06:11:42 GMT

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

prma7799 — Thu, 01 Oct 2015 06:24:06 GMT

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

jagan — Thu, 01 Oct 2015 06:24:13 GMT

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.