topic Re: Logic in QlikView

Logic

aveeeeeee7en — Fri, 25 Apr 2014 13:17:27 GMT

Hi All

Need Logic from Script:

MOB Desired Output by using MOB

10 10

20 10+20=30

30 10+20+30=60

40 10+20+30+40=100

50 10+20+30+40+50=150

Regards

Aviral

Re: Logic

rustyfishbones — Fri, 25 Apr 2014 13:22:09 GMT

Can you try in the script

Previous(MOB)/2 AS [New Field Requirement]

looks like this in my example

Re: Logic

its_anandrjs — Fri, 25 Apr 2014 13:25:40 GMT

Use Previous function.

Re: Logic

aveeeeeee7en — Fri, 25 Apr 2014 13:26:43 GMT

Hi Alan, I actually want this:

MOB Desired Output by using MOB

10 10

20 10+20=30

30 10+20+30=60

40 10+20+30+40=100

50 10+20+30+40+50=150

Re: Logic

rustyfishbones — Fri, 25 Apr 2014 13:31:59 GMT

Yes I see, I am trying to figure it out

Re: Logic

its_anandrjs — Fri, 25 Apr 2014 13:33:43 GMT

Provide your previous image also where you explain it will more clear.

Re: Logic

rustyfishbones — Fri, 25 Apr 2014 13:37:34 GMT

Use this expression

RangeSum(above(sum(MOB),0,RowNo()))

Re: Logic

rustyfishbones — Fri, 25 Apr 2014 13:41:45 GMT

you can also use

to get the running Average

hope that helps

Re: Logic

aveeeeeee7en — Fri, 25 Apr 2014 13:42:32 GMT

Thanks Alan, it is working Perfectly.

But I have used it earlier. As I said in my requirement, I need this thing from the Script not from my Chart Expression.

Re: Logic

maxgro — Fri, 25 Apr 2014 13:43:07 GMT

load

MOB,

alt(peek(MOBSUM),0) +MOB as MOBSUM;

load * inline [

MOB

];

EDIT

or this?

load

MOB,

alt(peek(MOBSUM),0) +MOB as MOBSUM,

if(rowno()=1, text(MOB), peek(MOBSUMTXT) & ' + ' & text(MOB)) as MOBSUMTXT;

load * inline [

MOB

];

Re: Logic

jerem1234 — Fri, 25 Apr 2014 13:44:13 GMT

You'll want to use:

rangesum(MOB, peek('NewField')) as NewField

in your script, but need to make sure your sorting is correct.

Find attached for example.

Hope this helps!

Re: Logic

NareshGuntur — Fri, 25 Apr 2014 13:53:28 GMT

Hi Nag,

Please use the following script.

Credits to Jagan Mohan.(How can I calculate a cumulative sum in load script?)

TableName:

LOAD

F1,

F2,

RangeSum(F2, Peek('CumSum')) AS CumSum;

LOAD * INLINE [

F1, F2

a, 100

b, 200

c, 300

d, 400

];

Cheers,

Naresh

Re: Logic

its_anandrjs — Fri, 25 Apr 2014 13:58:02 GMT

Use Range sum in the front end and also you can do this in the load script like

LOAD

Joining,

Leaving,

MOB,

Month,

Year,

RowNo() as ID,

RangeSum(MOB, Peek('CumalativeSum')) AS CumalativeSum

FROM

Book2.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: Logic

aveeeeeee7en — Fri, 25 Apr 2014 14:07:11 GMT

Thank You Guys,

So many Answers in little time and that too of so much varieties. Loved Qlikview Community &its Awesome Developers. All answers are Perfect in their own ways.

Once Again, Thanks for the Answers and your time.

Regards

Aviral

Re: Logic

aveeeeeee7en — Fri, 25 Apr 2014 14:11:12 GMT

Hey Massimo, Your answer was awesome. Loved it.