Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Creator
Creator

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
Highlighted
MVP & Luminary
MVP & Luminary

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Creator
Creator

Hi kaushik.solanki‌ ,

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

Highlighted
Specialist
Specialist

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

Highlighted
MVP & Luminary
MVP & Luminary

Hi,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Creator
Creator

Hi @Andreykrylov,

can you just brief about this ?

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

Highlighted
Creator
Creator

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