Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

YTD

May I know how to create YTD for my data set below?

I don't have a date format like, 31/1/2019.

Am new to Qlik, thanks for your help!

 

                                                               Prior Year
 ActActActActActActActActActActActAct
AccountM01M02M03M04M05M06M07M08M09M10M11M12
AAA27.0942.0029.3725.9527.2515.5131.3421.1613.0029.2130.7251.62
BBB10.6811.1012.6811.0015.489.0013.5814.3513.8712.7416.6712.76
CCC(0.00)0.00(0.00)0.000.00(0.00)0.00(0.00)(0.00)(0.00)0.00(0.00)
DDD0.000.000.000.000.000.000.000.000.000.000.000.00
EEE0.000.000.000.000.000.000.000.000.000.000.000.00
FFF0.160.400.210.210.200.190.160.170.150.080.020.21
Labels (1)
2 Replies
Contributor
Contributor

Actually, the row "Prior Year" covers all from M01 to M12.

Digital Support
Digital Support

I believe Set Analysis is likely the best way to go, check the following Design Blog post, hopefully they will help get you on the right track:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

There is a link to the Primer post on this one, so you can review that one too if need be, hopefully this helps.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.