Dynamic scripting

Mon, 26 Jan 2026 18:19:17 GMT

hi Qv,

Temp:

LOAD Name,

Date,

Year(Date) as Year,

Sales

FROM

Data.xlsx

(ooxml, embedded labels, table is [Dummy Sales]);

Temp1:

NoConcatenate

LOAD

Resident Temp

Order by Name, Date;

DROP Table Temp;

CumulativeSum:

NoConcatenate

LOAD

Name,

Date,

Year,

Sales,

If(Name <> Previous(Name) or Year <> Previous(Year), Sales, RangeSum(Sales, Peek('CumulativeSum'))) AS CumulativeSum

Resident Temp1;

DROP Table Temp1;

---------------------------------------------------------------------------------

i have done Cumulative sum for above and the problem is i need commission for Different names commision may vary how to give dynamic in set analysic plz help me

Name

Year

Slab(cumulativesum)

Commission

Peter

2014

$0-$50000

peter

2014

$50001-$100000

1.5%

peter

2014

$100001-$150000

peter

2014

>$150001

2.5%

john

2014

$0-$50000

1.5%

like this the commision varies depends on Name and slab plz help

-lohi

topic Dynamic scripting in QlikView

Dynamic scripting