topic Re: How to link new excel file to existing data model in QlikView

How to link new excel file to existing data model

prma7799 — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I have one application which is based on link table concept.

I have one requirement in application i want target value which present in attached file.

Can anyone suggest me that How can I start.

I started to work on it but not getting success on selection . I faced one issue that I got target values but when I select any Month or Quarter or Year then Target values not changed.

Thanks

Re: How to link new excel file to existing data model

Anonymous — Tue, 02 Feb 2016 06:49:29 GMT

Why not Partial load?

Partial Reload in QlikView: Part I

just do like this?

add only //For Partial Relaod

load

From Excel;

Now go to -> File Menu -> Partial Load

Re: How to link new excel file to existing data model

prma7799 — Tue, 02 Feb 2016 06:53:20 GMT

Hi Balraj,

This is not I want. I want when I select any month then target values are not showing for that respective month.

Thanks

Re: How to link new excel file to existing data model

prma7799 — Tue, 02 Feb 2016 11:01:43 GMT

Any guidance on this?

Re: How to link new excel file to existing data model

Mahamed_Qlik — Tue, 02 Feb 2016 11:04:32 GMT

Hi,

Create one primary key which is to be needed to associate your excel data with your existing data model.

Then you can easily concatenate you excel file file to your data model.

Hope it helps you out...!

Regards,

Mahamed

Re: How to link new excel file to existing data model

prma7799 — Tue, 02 Feb 2016 11:23:25 GMT

Hi Mahamed , tresesco‌ , swuehl‌ , sunindia‌

PFA of my requirement..

Thanks

Re: How to link new excel file to existing data model

Mahamed_Qlik — Tue, 02 Feb 2016 11:25:17 GMT

No attachement.

Re: How to link new excel file to existing data model

prma7799 — Tue, 02 Feb 2016 11:39:55 GMT

PFA

Re: How to link new excel file to existing data model

tresB — Tue, 02 Feb 2016 11:42:28 GMT

Is there any Month field in your Target (excel) table ? If not, generate a Month field using

Month(DatefIeld) as MONTHSs

Then applying join (on both Div_code and MONTHSs, i.e. composite key) would probably give you the expected output.

Re: How to link new excel file to existing data model

prma7799 — Tue, 02 Feb 2016 11:48:39 GMT

Hi Tresesco,

I dont have any Date field in my excel but yes I have Months column in excel and I converted it into cross table as MONTHSs.

So how can generate DatefIeld as you suggested above.

Please help.

Thanks

Re: How to link new excel file to existing data model

tresB — Tue, 02 Feb 2016 11:59:16 GMT

Could you post a screen shot of your data model?

Re: How to link new excel file to existing data model

vikasmahajan — Wed, 03 Feb 2016 07:15:24 GMT

Prashant use this following formula to get correct sales of last year jan

Sum({<DATE={">=$(=MonthStart(Max(DATE),-12)) <=$(=MonthEnd(Max(DATE)))"}>} SALES)

Re: How to link new excel file to existing data model

prma7799 — Wed, 03 Feb 2016 10:10:46 GMT

Sir...

You are right but this is different question.

Thanks