Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

bhavvibudagam
Contributor II

correction needed in the attached app

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,

1 Solution

Accepted Solutions
MVP
MVP

Re: Left join correction needed in the attached app

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
Not applicable

Re: Left join correction needed in the attached app

Dear Bhavani,

Please find the attachment for required output.

Thanks & Regards,

Neha Malekar

MVP
MVP

Re: Left join correction needed in the attached app

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Re: Left join correction needed in the attached app

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)