Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

munna1317
Contributor II

Help In Scripting Plz

hi QV's,

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

i have fields

NameDateYearSalesCumulativeSumCommission

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

5 Replies

Re: Help In Scripting Plz

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

regards

Marco

munna1317
Contributor II

Re: Help In Scripting Plz

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

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

munna1317
Contributor II

Re: Re: Help In Scripting Plz

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

munna1317
Contributor II

Re: Re: Help In Scripting Plz

sory for wrong attachment plz follow this

Community Browser