topic Re: Re: Set analysis Problem in QlikView

Set analysis Problem

munna1317 — Mon, 22 Sep 2014 17:27:14 GMT

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

Re: Set analysis Problem

anbu1984 — Mon, 22 Sep 2014 17:30:31 GMT

Can you explain your requirement

Re: Set analysis Problem

munna1317 — Mon, 22 Sep 2014 17:33:33 GMT

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

Re: Set analysis Problem

anbu1984 — Mon, 22 Sep 2014 17:44:41 GMT

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

Re: Set analysis Problem

munna1317 — Mon, 22 Sep 2014 17:57:25 GMT

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

Re: Set analysis Problem

Anonymous — Mon, 22 Sep 2014 19:10:48 GMT

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

Re: Set analysis Problem

maxgro — Mon, 22 Sep 2014 23:14:13 GMT

see attachment

Re: Re: Set analysis Problem

munna1317 — Tue, 23 Sep 2014 05:42:39 GMT

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

Re: Re: Set analysis Problem

munna1317 — Tue, 23 Sep 2014 08:39:32 GMT

hi konstantins kozins,

Please find the attachment

Regards ,

Harish

Re: Set analysis Problem

munna1317 — Tue, 23 Sep 2014 12:35:54 GMT

hi maxgro,

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

thxs

harish