topic Re: Error in below scrip? in QlikView

Error in below scrip?

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

Calculate past 3 months total sales in stright table?

Datamodel:

Month sales

Dec. 500

Jan. 600

Feb. 800

Mar. 700

Apr. 400

I write below expression to get past three months total sales.

Sum({<Month_Num = {">=$(=AddMonths(Max(Month), -2)) <=$(=Max(Month))" >} Sales)

If month field available Dec and Jan like that. So how to convert to date.

My requirement calculate past 3 months sales.

Thanks

Chaitanya

mdmukramali — Sat, 18 Nov 2017 05:47:38 GMT

Hi,

Do you have Year Field in the Data Model?

Thanks,

Mukram

its_anandrjs — Sat, 18 Nov 2017 06:15:54 GMT

Do you have Numeric Month field it is shown in your expression let me know what fields you have.

its_anandrjs — Sat, 18 Nov 2017 06:20:40 GMT

If you have Numeric Month Field that try this way

Sum({< Month_Num= {">=$(=(Max(Month_Num)-2)) <=$(=Max(Month_Num))"} >} Sales)

gkcchowdary — Sat, 18 Nov 2017 06:32:57 GMT

Hi anand I don't have numeric month field. If any way to convert my data into numeric date.

its_anandrjs — Sat, 18 Nov 2017 07:06:01 GMT

In your load script where you have Month filed put this line

Load

Num(Month(Month)) as NumMonth

From Source;

its_anandrjs — Sat, 18 Nov 2017 07:06:54 GMT

Ohh not this

Load

Num(Month(Month)) as NumMonth

Num(Month) as NumMonth

From Source;

Anil_Babu_Samineni — Mon, 20 Nov 2017 03:41:50 GMT

How you want to convert date if Dec is month?