Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
berryandcherry6
Contributor II

Creating Summary table in qliksense using Script

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.


2 Replies
neelima_g36
New Contributor III

Re: Creating Summary table in qliksense using Script

Can you provide sample data?

miskin_m
Contributor

Re: Creating Summary table in qliksense using Script

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