topic Subtract Data in QlikView

Subtract Data

Dayna — Wed, 23 Sep 2009 20:55:23 GMT

Good Afternoon,

I am hoping that you guys could help me, my task seems a simple one but I don't know how to do it.

Basically, I have a record that shows me the level of stock for today, and I have a table that records dates and changes made to that stock. What I need to do, is take today's result, and subtract the changes made from yesterday. I need to get this data to show for the last 13 weeks (91 days worth of changes)…

I'm going on the training course in a few weeks, which will hopefully stop me from nagging you guys! But as always, you're help will be most appreciated.

Kind Regards,

Dayna

Subtract Data

Wed, 23 Sep 2009 21:37:32 GMT

Where is your source data? (SQL Server, text files, etc.)

Subtract Data

Dayna — Wed, 23 Sep 2009 21:43:12 GMT

Hello,

It is coming from ODBC Data Connection from a Progress Database.

Kind Regards,
Dayna

Subtract Data

Wed, 23 Sep 2009 22:04:13 GMT

could you upload a QV with an example of your data?

Subtract Data

Dayna — Wed, 23 Sep 2009 22:34:15 GMT

Hello,

The attachment shows the data we will be using, the chart shows the forecasted sales for the last 13 weeks and next 13 weeks. I am trying to add the actual stock figures using the table in_mstr_m for in_qty_oh_m for the last 13 weeks (different tables will be used for the next 13 weeks, but same theory applies).

The stock changes are in a table called tr_hist, fields tr_qty_chg and the dates them changes applied are tr_effdate.

Kind Regards,
Dayna

Subtract Data

Dayna — Thu, 24 Sep 2009 15:49:46 GMT

Subtract Data

Dayna — Mon, 28 Sep 2009 16:01:42 GMT

Hello,

Can anyone assist with the above please?

Regards,

Dayna