Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ramcena306
Creator II
Creator II

Data Limitations

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

1 Solution

Accepted Solutions
ramcena306
Creator II
Creator II
Author

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

View solution in original post

7 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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/conve...

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
ramcena306
Creator II
Creator II
Author

Hi kaushik.solanki‌ ,

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

andrey_krylov
Specialist
Specialist

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
ramcena306
Creator II
Creator II
Author

Hi @Andreykrylov,

can you just brief about this ?

andrey_krylov
Specialist
Specialist

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.

ramcena306
Creator II
Creator II
Author

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