topic same script different years in QlikView

same script different years

Anonymous — Fri, 17 Jun 2011 07:21:02 GMT

Hi!

I have a script based on a lot of excel fiels due to goals a company has set.

They have goals for 2 years (different files but similar data) and in the script they've duplicated the script to another sheet. Hence, one sheet for one year.

I'm thinking there must be an easier way to do this but i can't figure it out. Any suggestions?

//A.

same script different years

kaushiknsolanki — Fri, 17 Jun 2011 07:45:18 GMT

Hi,

Can you please explain, why do you require the different files when the data is same.

Its not recommended to have two scipts for same data with different table names.

The reason is it will overload the application.

If you can explain in more detail, that will help us to figure out the problem and find the solution.

Regards,

Kaushik Solanki