topic Re: Left join correction needed in the attached app in QlikView

correction needed in the attached app

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

Hi Experts,

Can any one please help me on below scenario.

I have 4 input files.

Config File is the Main Table.

PG,Capabily and Coverage are the Subtables.

In between Config and PG the common Field is PG.Based on PG need to do left join.
In between Config and Capability common Field is Capability.Based on Capability need to do left join.
In between Config and Coverage common Field is Coverage.Based on Coverage need to do left join.

Here only first left join is working. please help me on this.

when PG is not null then PG hours comes under Hours field.

When PG and Capability is null then Hours related to Coverage comes under Hours field.

When PG and Coverage is null then Hours related to Capability comes under Hours field.

Thanks in advance,

Re: Left join correction needed in the attached app

Thu, 30 Nov 2017 04:19:03 GMT

Dear Bhavani,

Please find the attachment for required output.

Thanks & Regards,

Neha Malekar

Re: Left join correction needed in the attached app

jonathandienst — Thu, 30 Nov 2017 04:58:11 GMT

Why join the tables? You can let QV associations do all the work for you.

You will need to rename the hours fields to prevent them being associated. you could do this by using Qualify Hours before loading the tables.. Then you will get 4 tables associated by PG, Capability and Coverage. Your expression could then be

=Alt(PG.Hours, Capability.Hours, Coverage.Hours)

Re: Left join correction needed in the attached app

Anil_Babu_Samineni — Thu, 30 Nov 2017 05:13:22 GMT

Don't dump for single solution Re: Left join Help