QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for
Did you mean:
Creator 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

9 Replies
Master III

Creator II
Author

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

Master III

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
Creator II
Author

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

Creator III

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

MVP

see attachment

Creator II
Author

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

Creator II
Author

Regards ,

Harish

Creator II
Author

hi maxgro,

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

thxs

harish