topic Re: Sync keys issue in QlikView

Sync keys issue

Wed, 10 Oct 2012 13:47:52 GMT

Dear All,

I have following scenerio,

Users:

load * inline [

userid, username

1, 'UserOne'

2, 'UserTwo'

3, 'UserThree'] ;

Opportunity:

load * inline [

opportunityid, userid, date

1, 1, '10/10/2012'

2, 1, '10/10/2012'

3, 1, '10/10/2012'

4, 2, '10/10/2012'

5, 2, '10/10/2012'

6, 3, '10/10/2012'] ;

Lead:

load * inline [

leadid, userid, date

1, 1, '10/10/2012'

2, 1, '10/10/2012'

3, 1, '10/10/2012'

4, 2, '10/10/2012'

5, 2, '10/10/2012'

6, 3, '10/10/2012'] ;

Order:

load * inline [

orderid, userid, date

1, 1, '10/10/2012'

2, 1, '10/10/2012'

3, 1, '10/10/2012'

4, 2, '10/10/2012'

5, 2, '10/10/2012'

6, 3, '10/10/2012'] ;

Calendar:

Load * Inline [

date, year, month

'10/10/2012', '2012', '10'

]

Below is the Syn key shown. how can i remove sync key and be able to select data by both date and userid

Kind Regards,

Muhammad Naveed

Re: Sync keys issue

Wed, 10 Oct 2012 16:36:19 GMT

Join Opportunity, Lead, Order tables to User Table. Then join Calendar table to user Table and drop all the original tables except User table

Re: Sync keys issue

thomas_skariah — Fri, 12 Oct 2012 03:02:27 GMT

Hi Naveed,

You can refer the below attcahed qvw file.

Regrads,

Tom

Re: Sync keys issue

Siva_Sankar — Fri, 12 Oct 2012 05:16:25 GMT

Hi Muhammad Naveed, Find the attached file.