Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

munna1317
Contributor II

Set analysis Problem

hi Qvs ,

I have Fields like this

CumulativeSumCommission
95310.01
186160.01
251850.01
328870.01
401310.01
428540.01
431840.01
505940.01
550860.01
598970.01
672570.015
758100.015
809160.015
879580.015
895880.015
965750.015
990790.015
1059990.02
1096900.02
1166890.02
1236500.02
1252500.02
1347190.02
1362530.02
1382630.02
1465170.02
1469500.02
1484660.02

the Output Should be :

CumulativeSumCommission
95310.01
186160.01
251850.01
328870.01
401310.01
428540.01
431840.01
505940.01
550860.01
600000.01
72570.015
758100.015
809160.015
879580.015
895880.015
965750.015
1000000.015
59990.02
96900.02
166890.02
236500.02
252500.02
347190.02
362530.02
382630.02
465170.02
469500.02
484660.02

Plz help in this

Thxs ,

Harish

9 Replies
anbu1984
Honored Contributor III

Re: Set analysis Problem

Can you explain your requirement

munna1317
Contributor II

Re: Set analysis Problem

hi anbu ,

thxs for rply , req is :

at end of each commission its needs to

600000.01

1000000.015

and after that it should starts from

72570.015

59990.02

thxs ,

Harish

anbu1984
Honored Contributor III

Re: Set analysis Problem

Still not clear

598970.01   //Row is missing in output
672570.015  //Split to two rows

990790.015  //Row is missing in output
1059990.02   //Split to two rows
munna1317
Contributor II

Re: Set analysis Problem

Already there                                                      Output table

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           

konstantin
Contributor III

Re: Set analysis Problem

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

MVP
MVP

Re: Set analysis Problem

see attachment

munna1317
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

munna1317
Contributor II

Re: Re: Set analysis Problem

hi konstantins kozins,

Please find the attachment

Regards ,

Harish

munna1317
Contributor II

Re: Set analysis Problem

hi maxgro,

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

thxs

harish