topic Re: QTD calculation in script in App Development

QTD calculation in script

nakuldev — Tue, 21 Dec 2021 21:56:36 GMT

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 — Tue, 27 Apr 2021 20:31:12 GMT

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

nakuldev — Wed, 28 Apr 2021 05:02:00 GMT

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 — Wed, 28 Apr 2021 13:26:34 GMT

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)