topic Re: Data Limitations in QlikView

Data Limitations

ramcena306 — Wed, 25 Nov 2020 16:16:04 GMT

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).

jimhalpert theresaa jimhalpert laughsmile jimhalpert stalwar99 jimhalpert

Thanks in Advance,

Ramesh

Re: Data Limitations

kaushiknsolanki — Tue, 04 Sep 2018 06:42:49 GMT

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.

https://help.qlik.com/en-US/sense-developer/June2018/Subsystems/Dev-Hub/Content/ConversionTool/conversion-tool.htm

Regards,

Kaushik Solanki

Re: Data Limitations

ramcena306 — Tue, 04 Sep 2018 06:45:54 GMT

Hi kaushik.solanki‌ ,

unfortunately we should use binary load, and we are migrating only datamodel to qliksense.

Re: Data Limitations

andrey_krylov — Tue, 04 Sep 2018 06:49:22 GMT

Hi, Ramesh, if I get your issue right I would make an inner join by [Date field] containing 3 last years.

Re: Data Limitations

kaushiknsolanki — Tue, 04 Sep 2018 06:52:12 GMT

Hi,

The converter allows you to migrate the data model as well.

Regards,

Kaushik Solanki

Re: Data Limitations

ramcena306 — Tue, 04 Sep 2018 07:01:27 GMT

Hi @Andreykrylov,

can you just brief about this ?

Re: Data Limitations

andrey_krylov — Tue, 04 Sep 2018 07:34:44 GMT

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.

Re: Data Limitations

ramcena306 — Tue, 04 Sep 2018 10:37:00 GMT

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