Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

franckwhite17
New Contributor II

how to have the year-to-date from the month fields?

Hello,

I would like to calculate the annual cumulation from the fields "month", since I do not have a fields year, how to proceed?

please ...

thank you for your reactions

4 Replies
MVP
MVP

Re: how to have the year-to-date from the month fields?

If you don't have a year field, can we safely assume that you have one year data only?

franckwhite17
New Contributor II

Re: how to have the year-to-date from the month fields?

i don't have year field

MVP
MVP

Re: how to have the year-to-date from the month fields?

Could you post a sample data set and expected output ?

franckwhite17
New Contributor II

Re: how to have the year-to-date from the month fields?

Here is the excel file I made a cross table in the script and I could have as fields: Data, month and sub indicator.

now I would like to have the year-to-date but using the month field that groups every month since I have no year fields.

29.PNG