Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mohanrajsubrama
Contributor II
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

5 Replies
mohanrajsubrama
Contributor II
Contributor II
Author


Hi Guys ,

Any update on the above requirement.

Regards,

Mohan

tobias_klett
Partner - Creator II
Partner - Creator II

Hi,

something like this?

Regards

Tobias

mohanrajsubrama
Contributor II
Contributor II
Author

Dear Tobias,

Did u upload some thing?

Regards,

Mohan

tobias_klett
Partner - Creator II
Partner - Creator II

Hi,

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

Regards

Tobias

mohanrajsubrama
Contributor II
Contributor II
Author

Dear Tobias,

I am not finding any attched file in my end.

Regards,

Mohan