Creating Summary table in qliksense using Script

[berryandcherry6]

Hi,

i have a table called BankMetrics where column's are

BankID,BankName,BankBranch,BankSubBranch,BankStartDate,BankEndDate,BankIntialAmount ,BankAccountAmount,  BankSafeAmount

My requirement is to create a single summary table in qliksense script, where it contains data column like

1.)sum(BankIntialAmount)  for PreviousMonth for each BankID

2.)sum(BankIntialAmount)  for CurrentMonth for each BankID

2.)sum(BankSafeAmount)  for CurrentMonth for each BankID

Here for PreviousMonth  and CurrentMonth date we can get from BankStartDate and BankEndDate.

How could i do this? Any idea or Suggestion is most welcomed

Please help me on this.

[Anonymous]

Can you provide sample data?

[miskin_m]

Hi,

You can create tables with limiting the data by Current Month and Previous month using where clause in load statement and then concatetating each table.Like

//Current Month

Table1:

Load

----

From original table where date(BankStartDate)>=MonthStart(Date(Today()))  and date(BankEndDate)<=MonthEnd(Date(Today()))

Concatenate

//Previous Month

Table 2:

Load

---

From Original Table where bank date is previous month