Discussion board where members can get started with Qlik Sense.
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.
Can you provide sample data?
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
From original table where date(BankStartDate)>=MonthStart(Date(Today())) and date(BankEndDate)<=MonthEnd(Date(Today()))
From Original Table where bank date is previous month