separate the database

[Anonymous]

I have 5 database and I want to make table in QlikView for these 5 dates, so when i select 2010 i want to view all data which related to 2010.

[tamilarasu]

Hi Mohammed,

My suggestion is to create a master calendar. I just take the collect date as key field in the table. Copy paste the below script in below your script. After reload the table will link with the Table and you can do selections.

MasterCalendar:

LOAD

    collectDate,

    Date(collectDate) AS Date,

    Day(%Date) As Day,

    Week(collectDate) As Week,

    Month(%Date) As Month,

    'Q' & Ceil(Month(collectDate) / 3) AS Quarter,

    Year(collectDate) AS Year

RESIDENT TableName; // You didnt mention any table name. Modify as per your need.

Or simply create a list box like below.

[santhosh_k_n]

HI,

While loading into Qlikview add a flag for each DB table say DB_Select and asign values as

Access2010 -> DB_Select=2010

Access2011 -> DB_Select=2011

Access2012 -> DB_Select=2012

BR

SK

[Anonymous]

can you explain more please, I'm new to qlikview.

I have a big database not only the data on the picture.. and there is duplication with it.

i want to select date 2010 from table and get only the data which related to 2010.

or if i can make a table contain access2010, access2011, access2012,..

so once i select access2010 i need to view the data which related to access2010.

sorry for bad english.

Regards,

[tamilarasu]

Did you try my solution.? What issue you are facing?

[santhosh_k_n · Accepted solution]

HI,

Try loading as below,

Load *, '2010' as DB_Select;

select * from Access2010;

concatenate

Load *, '2011' as DB_Select;

select * from Access2011; ......

by loading that, u can use DB_Select as the filter to present the data for respective DB i.e if u select 2010 it will present the 2010 data

BR,

SK

[Anonymous]

yes thanks for your answer its help me in other thing