Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Recently we are migrated only data model from Qlikview to Qliksence using binary load. The Question is how can we limit the Data model for QlikSense should only contain data for the most recent fiscal years(2016,2017,2018).
jimhalperttheresaajimhalpertlaughsmilejimhalpertstalwar99jimhalpert
Thanks in Advance,
Ramesh
Hi All,
I have worked on it,
TempTable:
LOAD
if(Month(today())<10,
Year(today()),
Year(today())+1) as [DateField]
AUTOGENERATE 1;
Concatenate (TempTable)
LOAD
if(Month(today())<10,
Year(today())-1,
Year(today())) as [DateField]
AUTOGENERATE 1;
Concatenate (TempTable)
LOAD
If(Month(Today())<10,
Year(Today())-2,
Year(Today())) as [DateField]
AutoGenerate 1;
INNER JOIN ([Your table with DateField])
Load * resident TempTable:
drop table TempTable:
Regards,
Ramesh
Hi,
When you do a binary load, I dont think you can restrict the data.
But I would suggest instead of doing binary load, try migrating the QlikView dashboard to QlikSense using the "QlikView Converter" available in Qlik Dev.
Regards,
Kaushik Solanki
Hi kaushik.solanki ,
unfortunately we should use binary load, and we are migrating only datamodel to qliksense.
Hi, Ramesh, if I get your issue right I would make an inner join by [Date field] containing 3 last years.
Hi,
The converter allows you to migrate the data model as well.
Regards,
Kaushik Solanki
Hi @Andreykrylov,
can you just brief about this ?
Well, you need a date table like below
TempTable: LOAD Date('2016-01-01' + IterNo() - 1) as [DateField] AutoGenerate 1 While Date('2016-01-01' + IterNo() - 1) <= Date('2020-01-01');
then join them
Inner Join([Your table with DateField])
LOAD * Resident TempTable;
Drop table TempTable;
And date format should be considered.
Hi All,
I have worked on it,
TempTable:
LOAD
if(Month(today())<10,
Year(today()),
Year(today())+1) as [DateField]
AUTOGENERATE 1;
Concatenate (TempTable)
LOAD
if(Month(today())<10,
Year(today())-1,
Year(today())) as [DateField]
AUTOGENERATE 1;
Concatenate (TempTable)
LOAD
If(Month(Today())<10,
Year(Today())-2,
Year(Today())) as [DateField]
AutoGenerate 1;
INNER JOIN ([Your table with DateField])
Load * resident TempTable:
drop table TempTable:
Regards,
Ramesh