Rolling YTD

stephane_kosior · ‎2020-03-23

Hi,

I would like to a YTD calculation each month instead of having the % of each month ..

Thanks

Taoufiq_Zarra · ‎2020-03-23

can you develop and share a sample data ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

stephane_kosior · ‎2020-03-23

I can't share data as they are confidentials.

Let's say that :

SQL

Select

Date_Payment

,Case When Date_Payment > Date_Due Then 'Late' else 'OnTime' END as Payment_Status

FROM

maTable;

Brett_Bleess · ‎2020-04-14

Check the following Design Blog post, may give you some ideas:

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

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.

ytd

Related Topics