QTD calculation in script

[nakuldev]

Hi All,

I am getting MTD and YTD data directly from the user (source excel file), however user requested me to develop QTD in Qlik sense script.

Could someone guide me with this?

Thanks for the support in advance.

Regards

Nakul

[jwjackso]

I just recommended Henric's As-Of-Table for another solution, but it should help you as well.

[nakuldev]

Thank you for the response Jackson!

The issue is, dashboard was already in production, now I can't do any changes to the charts.

Thanks

Nakul

[jwjackso]

In a chart, your QTD can be as simple as

Jan-QTR1 = Sum({<Year={'2021'},Mth={'Jan'}>}Sales)

Feb-QTR1 = Sum({<Year={'2021'},Mth={'Jan','Feb'}>}Sales)

Mar-QTR1 = Sum({<Year={'2021'},Mth={'Jan','Feb','Mar'}>}Sales)

Apr-QTR2 = Sum({<Year={'2021'},Mth={'Apr'}>}Sales)

The YTD

Jan-YTD = Sum({<Year={'2021'},Mth={'Jan'}>}Sales)

Dec-YTD = Sum({<Mth={'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'}>}Sales)