Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ramcena306
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
ramcena306
Creator
Creator
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

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".
ramcena306
Creator
Creator
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

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".
ramcena306
Creator
Creator
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
Creator
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