topic Re: Joining between tables in QlikView

Joining between tables

narender123 — Tue, 02 Jul 2013 07:39:16 GMT

Hi All,

I have joined my table according to query but the problem starts when i count the "RaidField1" record .

As shown in Attached screen shot.

In screen shot Decleration header is Fact table.I have created the calender from receipt date of decleartion header table.All Table works fine except 1 table "Risk_Rsk_Analysis_Det.Actually i want to count the no. of Raid_Field1 based on date of "Raid_Revision_Date".

What i have to do with my datamodeling???

Thanks in Advance

Narender.

Re: Joining between tables

narender123 — Tue, 02 Jul 2013 08:47:56 GMT

Hello Guys.

Any Idea please??

Thanks

Re: Joining between tables

kaushiknsolanki — Tue, 02 Jul 2013 08:48:59 GMT

Hi,

What is the error you are getting.

Regards,

Kaushik Solanki

Re: Joining between tables

narender123 — Tue, 02 Jul 2013 09:00:14 GMT

Hi,

Thanks for reply.

It showing the wrong count due to taking received date based calender.

When i removed the receipt date means taking Raid_Revision_Date based calender then it showed the right result.But as i want calender based on receipt date but for count(raid_field1) it uses date that means Raid_Revision_Date.

Final result should be: Count(Raid_feild1) based on Raid_Revision_Date.

Re: Joining between tables

kaushiknsolanki — Tue, 02 Jul 2013 09:09:19 GMT

Hi,

Its because you have multiple records for each of the RA_CODE in the Risk analysis detail table.

Kindly post your qvw file.

Regards,

Kaushik Solanki

Re: Joining between tables

narender123 — Tue, 02 Jul 2013 09:36:53 GMT

Sorry Kaushik.

Its heaving very large data .

could you suggest me what i have to do??

Thanks

Re: Joining between tables

kamalqlik — Tue, 02 Jul 2013 09:45:14 GMT

Hi Just debug it for 100 rows and than paste your qvw.

Regards

Kamal

Re: Joining between tables

narender123 — Tue, 02 Jul 2013 09:52:06 GMT

Hi Kamal.

You are right.But the problem is not like that actually its about project confidentiality.

Thanks for reply.

Narender

Re: Joining between tables

narender123 — Tue, 02 Jul 2013 09:57:33 GMT

Thanks Mohit.

I dont know keep left funtion??

You mean left join.

I didnt use any left join between tables.Tables connected automatically via same dimention .

Thanks

Narender

Re: Joining between tables

kamalqlik — Tue, 02 Jul 2013 10:03:11 GMT

Hi Narendra,

your both field are coming from the same table ie Raid_Field1 and Raid Revision Date.

So can you just load that table and validate the datamodel value and please let me know how much differnce are you getting.

Regrads

Kamal

Re: Joining between tables

narender123 — Tue, 02 Jul 2013 10:07:28 GMT

Hi,

Its showing correct result when i remove recipt date and takes Raid Revision Date. as calender date.

I just want Raid Revision Date work for this count(Raid_Field1) and for other report works on recipt_date via making receipt date as calender.

Thanks.

Re: Joining between tables

kamalqlik — Tue, 02 Jul 2013 10:16:42 GMT

Hi Narendra,

Do one thing

Just make a master calendar and link all the date with that master calendar.

Than you will get the correct data as per your requirement.

Meanwhile you are not able to track the correct date.

That is why it is showing the wrong result

Regards

Kamal

Re: Joining between tables

er_mohit — Tue, 02 Jul 2013 10:19:00 GMT

no Left Keep function only load those records from which table you have large

suppose i have a table with 1000 records

load

field1,

field2,

field3

from table;

left keep

B: // in this table suppose i have 550 records and i want to load this records only so i using left keep it doesn't join the table it works on input records

load

field1,

field3,

field4

from table;

Re: Joining between tables

narender123 — Tue, 02 Jul 2013 10:19:53 GMT

Hi.

If i connect master calender with receipt date and Raid Revision Date.then it will make the circular loop because both date table are connect to another intermidiate table that is risk analysis table.

Thanks

Re: Joining between tables

narender123 — Tue, 02 Jul 2013 10:24:29 GMT

So from your point of view where i have to place the left keep function??

As i have shown my current table structure in attachment.

Please tell me.

Thanks.

Narender

Re: Joining between tables

kamalqlik — Tue, 02 Jul 2013 10:30:19 GMT

Hi Narendra,

When you will make a master calendar.

Suppose

Tempdate as Date

from Master calendar;

Load the other table:

RecieptDate as Date,

RecieptDate as Flag

Load the other table

[Rate Revision Date] as Date

Rate Revision Date as Flag

This will not lead as a result for circular refrence

and ou can use the flag for date identification

Regards

Kamal

Re: Joining between tables

er_mohit — Tue, 02 Jul 2013 10:31:49 GMT

between both Risk Table

Re: Joining between tables

narender123 — Tue, 02 Jul 2013 10:43:23 GMT

Hi Kamal.

Thanks .

But As you said all three date are same and when you check it via Ctrl+t means datamodeling.It will show circular loop as all 3 names are same.

Re: Joining between tables

narender123 — Tue, 02 Jul 2013 10:44:07 GMT

Ok Mohit .I will check it and let you know.

Thanks.

Narender