topic Re: Getting value from previous column, from previous week in QlikView

Getting value from previous column, from previous week

Wed, 08 Jul 2015 13:58:13 GMT

Hello.

I've got something like this:

and I've got a question about this:

How could I make CurrentStock be equal to Bilans from previous week (Fabric_CW)?

I've tried a few solutions and none of them was able to get value from another week(for example, column() gets values only from the same week and isn't able to get values from another set of fields - here, from previous week)

Re: Getting value from previous column, from previous week

sunny_talwar — Wed, 08 Jul 2015 14:08:19 GMT

May be this:

Before(YourExpression) //yourExpression needs to have a set analysis {<Fabric_CW = {'Bilans'}>}

Re: Getting value from previous column, from previous week

Mon, 13 Jul 2015 07:44:38 GMT

Hello,

Could you expand your answer?

Either it's not working or I don't understand it.

Re: Getting value from previous column, from previous week

sunny_talwar — Mon, 13 Jul 2015 10:07:29 GMT

Can you share the expression you are using right now???

Re: Getting value from previous column, from previous week

Mon, 13 Jul 2015 11:12:23 GMT

It looks like this:

Bilans: Supply - DemandLeft (shortened version)

and expanded version (Bilans):

(SUM({<FACTORY_STOCK_ID>} S_FABRIC_SUPP_QTY_CON - S_FABRIC_SUPP_QTY_DEL)) - (IF(FACTORY_ID=FACTORY_STOCK_ID, SUM({<FABRIC_ID>}S_FABRIC_QTY), 0)) - (IF(FACTORY_ID = FACTORY_STOCK_ID, SUM({<S_FABRIC_CW>} S_FABRIC_NED), 0))

Re: Getting value from previous column, from previous week

sunny_talwar — Mon, 13 Jul 2015 11:28:16 GMT

Would you be able to share a trimmed down version of your app or a sample to look at?

Re: Getting value from previous column, from previous week

Mon, 13 Jul 2015 11:49:02 GMT

I attached file with this table, Everything looks like this, but I'd like to have bilans from week 27 at week 28 (it can't be just calculated from the previous week, because I'll need it for much more weeks)

Re: Getting value from previous column, from previous week

sunny_talwar — Mon, 13 Jul 2015 12:03:17 GMT

Is this what you are intending to get?

If yes then please find attached

Best,

Sunny

Re: Getting value from previous column, from previous week

Mon, 13 Jul 2015 12:06:03 GMT

Yes, that's great.

I didn't know that it works like this, thank you very much!

Re: Getting value from previous column, from previous week

sunny_talwar — Mon, 13 Jul 2015 12:08:48 GMT

No problem

I am glad I was able to help.

Best,

Sunny

Re: Getting value from previous column, from previous week

Wed, 20 Jan 2016 20:22:35 GMT

Hi Sunny,

I have the same requirement. But before function works only with pivot table what if we need to represent this in a bar chart? If you have any work around for this please share it. Much appreciated !!

Thanks