topic Re: PMTD in QlikView

PMTD

ttal7878 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the following expression that display the sum of Sale_Amount$ of previous month:

=Sum({<Year=,Month=,Date=, DateKey={">=$(=Num(MonthStart(Max(DateKey), -1)))<=$(=num(max(MonthEnd(DateKey,-1))))"}>} Sale_Amount$)

I would like to modify the 'less than' portion to give me the beginning of previous selected month in a number format.

For example: if the user selects Month-02.2017 than the calculation will take into account the following dates:

01-01-2017 till 31-01-2017

Thanks

mdmukramali — Tue, 15 Aug 2017 08:51:22 GMT

Dear,

you can attach sample data set so that we can help you.

Thanks,

Mukram

pathiqvd — Tue, 15 Aug 2017 09:16:50 GMT

Hi,

Try this,

In script write like as date(MonthName(datefield),'MM.YYYY') as mnth_year

and write expr like

=Sum({<mnth_year={"$(=date(addmonths(max(mnth_year),-1),'MM.YYYY'))"}>}Sales)

and take mnth_year field as filter.

Regards,

kaushiknsolanki — Tue, 15 Aug 2017 09:20:38 GMT

Try this.

=Sum({<Year=,Month=,Date=, DateKey={">=$(=Num(MonthStart(Max(DateKey), -1)))<=$(=num(MonthEnd(Max(DateKey),-1)))"}>} Sale_Amount$)

Rergards,

Kaushik Solanki

ttal7878 — Tue, 15 Aug 2017 10:56:04 GMT

Attached is a sample report

I want to know if the calculation is correct