topic Re: Calculated Dimension in QlikView

Calculated Dimension

mohanrajsubrama — Mon, 16 Feb 2015 07:10:23 GMT

Dear All,

I have date column for 4 years and its respective sales.

Now my requirement is if my date column having values for entire year ie(till 31/12/2014)

then i need a extra row saying 2014 YTD , it should add all the values till Nov 31st 2014..

If i dont have values for the entire year then i need a row saying 2014 YTD ,it should add all the values till oct 31st 2014..

Please find the attached Screen shot of the requirement

mohanrajsubrama — Mon, 16 Feb 2015 08:46:54 GMT

Hi Guys ,

Any update on the above requirement.

Regards,

Mohan

tobias_klett — Mon, 16 Feb 2015 09:09:26 GMT

Hi,

something like this?

Regards

Tobias

mohanrajsubrama — Mon, 16 Feb 2015 09:48:47 GMT

Dear Tobias,

Did u upload some thing?

Regards,

Mohan

tobias_klett — Mon, 16 Feb 2015 09:53:38 GMT

Hi,

yes the "ytd.qvw". I put it here again.

Regards

Tobias

mohanrajsubrama — Mon, 16 Feb 2015 10:07:10 GMT

Dear Tobias,

I am not finding any attched file in my end.

Regards,

Mohan