topic How to do proper link of table in below script in QlikView

How to do proper link of table in below script

prma7799 — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

PFA file in that I have some query that I have to show Targets as YTD MTD QTD....

according to script my I did linking of two tables called FACT_GL_Entry with Targets. But I am unable to achieve YTD MTD QTD.

Please advise me.

Thanks

Chanty4u — Thu, 07 Apr 2016 08:01:55 GMT

did u chk dis

prma7799 — Thu, 07 Apr 2016 08:16:12 GMT

Hi Chanty,

This is not helpful for me. Have you check my script. I think my table linking is not proper.

So I want advise on that...

Please see attached

Thanks

HirisH_V7 — Thu, 07 Apr 2016 08:40:40 GMT

Hi,

Can you post some sample of your fields then it will easy.

-Hirish

prma7799 — Thu, 07 Apr 2016 09:13:00 GMT

Please find sample attachment

prma7799 — Thu, 07 Apr 2016 09:36:27 GMT

anyone can help on

Kushal_Chawda — Thu, 07 Apr 2016 09:44:09 GMT

i think you are joining this QVD on two field just join on Div_Code & try to link the Target on Div_Code

join (FACT_GL_Entry1)
//DIM_Division_Master:

LOAD

Div_Code,
Div_Name as Div_name1
FROM
[..\Qvds\NAVQVDS\DIMQVDivision.qvd]
(qvd);

prma7799 — Thu, 07 Apr 2016 09:51:06 GMT

Thanks Kushal

I will try and let you know.