Discussion Board for collaboration on QlikView Scripting.
Here is my load statement. I want to normalize the data with a primary index key.
From there I want to show:
AccountName - XYZ
BillStartDate - 1/1/2013
FiscalYearStartDate - 7/1/2012
Month(FiscalYearStartDate) as Month - 7
Month Index 1 since 7/1/2012 is the FiscalYearStartDate
AccountName - ABC
BillStartDate - 2/1/2013
FiscalYearStartDate - 8/1/2012
Month(FiscalYearStartDate) as Month - 8
Month Index 1 since 8/1/2012 is the FiscalYearStartDate
Does this make since? Can this be done.
If I'm following correctly, you can add:
1 as [Month Index]
or am I misunderstanding?
as my understood
date(BillStartDate,'MM') as [Month Index]