Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Any guidance on this?
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
No attachement.
PFA
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.
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