topic Re: How to subract the data in running total in QlikView

How to subract the data in running total

Wed, 25 Nov 2020 16:16:04 GMT

if I have a column inital_inv and first row has data and second row data will come

Initial Inv

200

Demand

Initial_inv-Demand

I need the output

200

150

130

How can i achive. Please help me.

Thanks,

Nishant

Re: How to subract the data in running total

sunny_talwar — Fri, 11 Nov 2016 14:11:19 GMT

You probably would need to use Peek() vs Previous() – When to Use Each to get this done. Here is another place you can read about it: Peek() or Previous() ?

For more detailed help, I would suggest you to provide a sample where we can see your data model to help you better

Re: How to subract the data in running total

Sat, 12 Nov 2016 12:44:10 GMT

Hello Sunny,

I have only one initial_inv as per Material code. Giving full example.

Material

Initial Inv

200

Demand

Output need

200

150

130

How this subtract will happen durning running the dashborad in qliksense.

Thank you for helping me.

Thanks,

Nishant

Re: How to subract the data in running total

Sat, 12 Nov 2016 18:09:49 GMT

Hello Sunny,

I got the result.. Thank you for helping me.

Now one more help i need.

I've a columns

Step 1

I need output like

Step 2

How can i count in reverse order and avoid the 0

thanks,

Nishant

Re: How to subract the data in running total

Anonymous — Sat, 12 Nov 2016 20:55:49 GMT

Hi Nishant,

Are You expecting this ?

On what basis it should be scripted ?

Re: How to subract the data in running total

Sun, 13 Nov 2016 04:42:58 GMT

Hello,

Yes, But need to write the expression in qliksense.

Can you provide me the solution .

Thanks,

Nishant