How to link new excel file to existing data model

[prma7799]

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

[Anonymous]

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

[prma7799]

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

[prma7799]

Any guidance on this?

[Mahamed_Qlik]

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

[prma7799]

Hi Mahamed , tresesco‌ , swuehl‌ , sunindia‌

PFA of my requirement..

Thanks

[Mahamed_Qlik]

No attachement.

[prma7799]

PFA

[tresesco]

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.

[prma7799]

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