Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show the records which contains a particular date range

Hi All,

I need to show the records which contains the particular date range.

I have a table as follows:

Notice NoLeader NameModel YearDate 1Date 2Date 3Date 4

I want to show all the records if I select a date range from calendar scroll and clicking the button. Even though the date range contains any date from the above 4 date fields it should show that row.

Thank You,

Abhijit

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Create a key in your table load using

Table1:

LOAD

    Recno() as RecID,

     NoticeNo,

     LeaderName,

     ModelYear,

     Date1,

     Date2,

     Date3,

     Date4

FROM ...;

//Then create a LinkTable:

LinkTable:

CROSSTABLE (DateField, Date)

LOAD RecID, Date1,Date2,Date3,Date4 RESIDENT Table1;

Now you can select your range from Date field or link this field to a master calendar.

View solution in original post

5 Replies
swuehl
MVP
MVP

Create a key in your table load using

Table1:

LOAD

    Recno() as RecID,

     NoticeNo,

     LeaderName,

     ModelYear,

     Date1,

     Date2,

     Date3,

     Date4

FROM ...;

//Then create a LinkTable:

LinkTable:

CROSSTABLE (DateField, Date)

LOAD RecID, Date1,Date2,Date3,Date4 RESIDENT Table1;

Now you can select your range from Date field or link this field to a master calendar.

Not applicable
Author

This works out well. Thank you Stefan. I didn't give try with Master Calendar. I would love to know about any specific approach while working with Date fields to get much deeper insights.

Abhijit

Not applicable
Author

Hi Stefan,

What would be the performance of the application when it will go live. I have 47,000 rows an excel file. I have 8 attributes which are date type. So technically Cross Table will convert is as 47000*8 rows. Will this impact a performance? If yes what would be a best approach to tackle this?

Abhijit

swuehl
MVP
MVP

I don't see a big performance penalty in your case.

Also keep in mind that you have now 8 times the number of rows, but only 3 instead of 9 fields, and aggregated number of distinct values (i.e. number of bits in your bit stuffed pointer) might be even unproportional smaller.

Just run some tests.

Not applicable
Author

Thank you Stefan. This answers my question.