topic Calculate YTD in QlikView

Calculate YTD

alvinford — Thu, 17 Feb 2011 18:32:46 GMT

Hi All,

Please find the attached excel ..I have the dimensions and the amount column in the Excel.

I want to calculate the YTD but not successful . Can anyone help me in calculating the YTD for the dimensions mentioned.

Want to calculate the YTD at the script level , Tried it using the peek function but not successful ...

Kindly requesting your help on YTD calculation.

Regards,

Ford.

Calculate YTD

suniljain — Thu, 17 Feb 2011 18:43:50 GMT

Dear Ford,

Pls check attached application that contain both static and dynamic calcultion.

Calculate YTD

matt_crowther — Thu, 17 Feb 2011 18:46:47 GMT

Ford,

Look into the inyeartodate() script function, this will essentially return a '1' if it your date is in the Year to Date and a '0' if it isn't.

Hope that helps,

Matt - Visual Analytics Ltd

Calculate YTD

alvinford — Mon, 21 Feb 2011 06:45:02 GMT

Hi,

Requesting your help on the YTD....

Regards,

Alvin.

Calculate YTD

suniljain — Mon, 21 Feb 2011 06:50:56 GMT

Pls check my posted application

Calculate YTD

alvinford — Mon, 21 Feb 2011 07:14:13 GMT

Dear Sunil,

I have checked your posted application, The problem is when I take the month as the dimension and value is not cummulated till the selected month. Can you please use the data provided by me and calculate the YTD.

Regards,

Alvin.

Calculate YTD

suniljain — Mon, 21 Feb 2011 07:58:01 GMT

I studied You data,

can you tell me one thing on which basis you want cumulation of data along with month and year.

Calculate YTD

Mon, 21 Feb 2011 09:44:11 GMT

Hi Ford,

There are multiple entries for each month which are not found to be differentiated by colums other than amount. check that and provide the same. Then we might a solution.

Regards,

-Karthik

Calculate YTD

alvinford — Mon, 21 Feb 2011 13:42:19 GMT

Hi Sunil,

I want cumulation on Month of every Year and for the dimensions also . When I click on a Year , Month and Particular dimension the value should be cumulative based on Year , Month & Dimension...

Regards,

Alvin.