topic divide by previous days value in QlikView

divide by previous days value

kamielrajaram — Mon, 09 May 2011 07:22:37 GMT

Good day,

I have a table that consists of descriptions on a daily basis and would like to work out the following

yesterdays figure /todays figure.

Col1, col2,col3

2011/03/01, Rum, 1.659

2011/03/02, Rum, 2.365

2011/03/03, Rum, 1.965

Thank you

Kamiel

divide by previous days value

Mon, 09 May 2011 07:39:11 GMT

Hi Kamiel,

Try using above function in the chart.

Regards

sravan

Re: divide by previous days value

kamielrajaram — Mon, 09 May 2011 07:45:54 GMT

Thank you,

That worked.

divide by previous days value

kamielrajaram — Mon, 09 May 2011 07:54:38 GMT

Thank you,

this worked fine until I selected a specific date. I do not get any value.

divide by previous days value

Mon, 09 May 2011 08:16:09 GMT

Hi Kamiel,

It is anyway clear if you are selecting one day from two days used in the formula that it does not work. Use Setananalysis to get the answer even after selection of a date. Try in search you get a lot of examples..

Regards

Sravan