topic Re: separate the database in QlikView

separate the database

Anonymous — Thu, 19 Nov 2015 07:11:09 GMT

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.

Re: separate the database

tamilarasu — Thu, 19 Nov 2015 07:16:58 GMT

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.

Re: separate the database

santhosh_k_n — Thu, 19 Nov 2015 07:18:24 GMT

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

Re: separate the database

Anonymous — Thu, 19 Nov 2015 07:47:15 GMT

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,

Re: separate the database

tamilarasu — Thu, 19 Nov 2015 07:48:33 GMT

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

Re: separate the database

santhosh_k_n — Thu, 19 Nov 2015 08:32:16 GMT

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,

Re: separate the database

Anonymous — Thu, 19 Nov 2015 09:41:28 GMT

yes thanks for your answer its help me in other thing