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: 
Anonymous
Not applicable

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
tresesco
MVP
MVP

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

Anonymous
Not applicable
Author

i don't have year field

tresesco
MVP
MVP

Could you post a sample data set and expected output ?

Anonymous
Not applicable
Author

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