topic Re: Joining between tables in QlikView

Joining between tables

narender123 — Wed, 12 Jun 2013 12:17:56 GMT

Hi Guys.

I have shown the data modeling diagram in attacment.

In the attachment , Declaration_Header table i have created a "newkey" based on Receipt_Date like Month(Receipt_Date) &'-'&Date(Receipt_Date) &'-'&Year(Receipt_Date) as newkey and connected it to Master calender its working fine.

But In Risk_Risk_Analysis_Details table I want to count "Raid_Field1" based on "Rad_Revision _Date" ."Rad_Revision _Date" is the Date of Raid _Field1.

What should i do????? With same Joins??

Re: Joining between tables

narender123 — Wed, 12 Jun 2013 13:24:50 GMT

Anyone give me some suggestion on this??

Thanks

Re: Joining between tables

Wed, 12 Jun 2013 13:31:44 GMT

i think

you count the "Raid_Field1" on the basis of "Rad_Revision _Date" .

then

in pivote table

dimension--Rad_Revision _Date

expression--count(Raid_Field1)

Re: Joining between tables

narender123 — Thu, 13 Jun 2013 05:05:00 GMT

Actually the dimention is "Consignee_Registraction" that is in Decleration Header Table.

With same joins it gives the count on Year that is made through Receipt _date.I want count based on "Rad_Revision _Date".

So Tell me what i have to do??

Thanks for the reply.

Re: Joining between tables

narender123 — Mon, 17 Jun 2013 06:06:55 GMT

Hi Guys.

Need your help please..

Thanks