topic Re: How can we calculate , Previous 12 months Totals in Script level (Not in UI level).. in QlikView

How can we calculate , Previous 12 months Totals in Script level (Not in UI level)..

madhubabum — Mon, 22 Jun 2015 06:08:54 GMT

Hi All....

How can we calculate , Previous 12 months Totals in Script level (Not in UI level)..

Thanks

Madhu

Re: How can we calculate , Previous 12 months Totals in Script level (Not in UI level)..

Mon, 22 Jun 2015 06:20:58 GMT

You may create another Fact table which will have Summary data and join this table to your main fact table.

Re: How can we calculate , Previous 12 months Totals in Script level (Not in UI level)..

svenkita — Mon, 22 Jun 2015 06:29:05 GMT

Let EndDate = MakeDate(2014,12,31);
Let StartDate = MakeDate(2014,1,31);

Item:
LOAD * INLINE [
ItemId, ItemName
1, Test Item 1
2, Test Item 2
];

Tmp:
LOAD * INLINE [
ItemId, Qty, Amount, SaleDate
1, 1, 1, 01/01/2014
1, 1, 1, 01/02/2014
1, 1, 1, 01/03/2014
1, 1, 1, 01/04/2014
1, 1, 1, 01/05/2014
1, 1, 1, 01/06/2014
1, 1, 1, 01/07/2014
1, 1, 1, 01/08/2014
1, 1, 1, 01/09/2014
1, 1, 1, 01/10/2014
1, 1, 1, 01/11/2014
1, 1, 1, 01/12/2014
2, 2, 2, 01/01/2014
2, 2, 2, 01/02/2014
2, 2, 2, 01/03/2014
2, 2, 2, 01/04/2014
2, 2, 2, 01/05/2014
2, 2, 2, 01/06/2014
2, 2, 2, 01/07/2014
2, 2, 2, 01/08/2014
2, 2, 2, 01/09/2014
2, 2, 2, 01/10/2014
2, 2, 2, 01/11/2014
2, 2, 2, 01/12/2014
];

TmpTotal:
Load ItemId, Sum(Amount) as TotalAmt
Resident Tmp
Where SaleDate >= '$(StartDate)' and SaleDate <= '$(EndDate)'
Group by ItemId;

Hope this Helps

Re: How can we calculate , Previous 12 months Totals in Script level (Not in UI level)..

madhubabum — Mon, 22 Jun 2015 06:29:28 GMT

Hi Shivendoo Kumar,

Can u please give me an example...

Thanks for ur reply.

Thanks

Madhu

Re: How can we calculate , Previous 12 months Totals in Script level (Not in UI level)..

Kushal_Chawda — Mon, 22 Jun 2015 06:52:06 GMT

Please go through this link. This will really help you

https://community.qlik.com/docs/DOC-4252

Re: How can we calculate , Previous 12 months Totals in Script level (Not in UI level)..

jagan — Mon, 22 Jun 2015 07:03:10 GMT

Hi,

Try like this

LOAD

If(DateFieldName > AddMonths(Today(), -12), 1) AS Last12MonthFlag

FROM DataSource;

Now in front end use

Sum({<Last12MonthFlag={1}>} Sales)

Hope this helps you.

Regards,

Jagan.