Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mohanrajsubrama
New Contributor II

Calculated Dimension


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

Tags (2)
5 Replies
mohanrajsubrama
New Contributor II

Re: Calculated Dimension


Hi Guys ,

Any update on the above requirement.

Regards,

Mohan

tobias_klett
Contributor II

Re: Calculated Dimension

Hi,

something like this?

Regards

Tobias

mohanrajsubrama
New Contributor II

Re: Calculated Dimension

Dear Tobias,

Did u upload some thing?

Regards,

Mohan

tobias_klett
Contributor II

Re: Calculated Dimension

Hi,

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

Regards

Tobias

mohanrajsubrama
New Contributor II

Re: Calculated Dimension

Dear Tobias,

I am not finding any attched file in my end.

Regards,

Mohan