# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Contributor II

## Set analysis Problem

hi Qvs ,

I have Fields like this

 CumulativeSum Commission 9531 0.01 18616 0.01 25185 0.01 32887 0.01 40131 0.01 42854 0.01 43184 0.01 50594 0.01 55086 0.01 59897 0.01 67257 0.015 75810 0.015 80916 0.015 87958 0.015 89588 0.015 96575 0.015 99079 0.015 105999 0.02 109690 0.02 116689 0.02 123650 0.02 125250 0.02 134719 0.02 136253 0.02 138263 0.02 146517 0.02 146950 0.02 148466 0.02

the Output Should be :

 CumulativeSum Commission 9531 0.01 18616 0.01 25185 0.01 32887 0.01 40131 0.01 42854 0.01 43184 0.01 50594 0.01 55086 0.01 60000 0.01 7257 0.015 75810 0.015 80916 0.015 87958 0.015 89588 0.015 96575 0.015 100000 0.015 5999 0.02 9690 0.02 16689 0.02 23650 0.02 25250 0.02 34719 0.02 36253 0.02 38263 0.02 46517 0.02 46950 0.02 48466 0.02

Plz help in this

Thxs ,

Harish

Tags (4)
9 Replies
Honored Contributor III

Contributor II

## Re: Set analysis Problem

hi anbu ,

thxs for rply , req is :

at end of each commission its needs to

 60000 0.01

 100000 0.015

and after that it should starts from

 7257 0.015

 5999 0.02

thxs ,

Harish

Honored Contributor III

## Re: Set analysis Problem

Still not clear

 59897 0.01   //Row is missing in output 67257 0.015  //Split to two rows

 99079 0.015  //Row is missing in output 105999 0.02   //Split to two rows
Contributor II

## Re: Set analysis Problem

CumulativeSum    Commission                CumulativeSum        Commission

59897                       0.01                                 60000                    0.01

67257                       0.015                               7257                  0.015

99079                      0.015                                 100000                  0.015

105999                    0.02                                     5999                       0.02

Contributor III

## Re: Set analysis Problem

it would be faster if you can provide Sum values, not only cumulative sum

MVP

see attachment

Contributor II

## Re: Re: Set analysis Problem

hi massimo ,

thxs for great rply , what you have done is exactly correct , but after 2 lakhs its getting '-' Vaules plz find the attactment, and let me knw if the solutuion

thxs ,

Harish

Contributor II

Regards ,

Harish

Contributor II

## Re: Set analysis Problem

hi maxgro,

any solution on above req , plz let me knw if any ,

thxs

harish

Community Browser