topic Help In Scripting Plz in QlikView

Help In Scripting Plz

munna1317 — Thu, 25 Sep 2014 15:06:34 GMT

hi QV's,

I dipped in this req plz help me and sort of this plz ,

i have fields

Name

Date

Year

Sales

CumulativeSum

Commission

with some data as following attachment ,

in excel there is a dummy field called

NewCumulative sum

i need output like values in Excel . plz help me ,

THXS IN ADVANCE ,

Harish

Re: Help In Scripting Plz

MarcoWedel — Thu, 25 Sep 2014 15:38:34 GMT

You might wish to explain your requirements a bit more in detail instead of opening new threads for the same question.

regards

Marco

Re: Help In Scripting Plz

munna1317 — Thu, 25 Sep 2014 15:42:38 GMT

hi Marco,

the requirement is same We have strucked it that problem, Plz help me with this problem

Thxs ,

Harish

Re: Help In Scripting Plz

MarcoWedel — Thu, 25 Sep 2014 16:02:42 GMT

your Excel sheet is not self explaining.

Can you explain, why your NewCumulativeSum field in one instance drops from 100000 to 5999 in another instance from 150000 to 53603 instead of 3603 when you are asking to round to the next 10000 value at the same time?

Another change of your Commission field from 0.025 to 0.01 on the other hand does not require rounding the 62714 value up to 70000?

I doubt that you will get a satisfying answer if you don't elaborate on your requirements.

hope this helps

regards

Marco

Re: Re: Help In Scripting Plz

munna1317 — Thu, 25 Sep 2014 16:27:37 GMT

hi marco , we got the requirement like that ,

i tied in different ways but the NewCumulativeSum is not come as per the excel that is just req , we need to sort of that how the NewCumulativeSum will com ,

Plz find the attachment it may help you to understand

Regards ,

Harish

Re: Re: Help In Scripting Plz

munna1317 — Thu, 25 Sep 2014 16:34:09 GMT

sory for wrong attachment plz follow this