topic Re: how to create front end field in Scripting in QlikView

how to create front end field in Scripting

prma7799 — Sat, 05 Sep 2015 11:54:26 GMT

Hi All,

I want to create one field in back end(scripting).

using below expression i want to create one field in back end

=aggr(if( rank(( ( sum({$<FiscalYear={$(=max(FiscalYear))}>}[Sales])) /100000),4)<=20,Brand), Brand)

Can anyone help me out.

Thanks

petter — Sat, 05 Sep 2015 12:59:36 GMT

In the Load Script:

LET vSales = 'aggr(if( rank(( ( sum({$<FiscalYear={$' & '(=max(FiscalYear))}>}[Sales])) /100000),4)<=20,Brand), Brand)';

In an expression in the UI:

$(vSales)

prma7799 — Mon, 07 Sep 2015 04:12:46 GMT

Is this variable will work into nprinting,i want one field (top 20) for creating excel reports in Nprinting.

Thanks