How to Connect table with 2 Column

brijeshvma — Fri, 30 Oct 2015 09:45:46 GMT

hi,

i m new in qlikview. i have 1 simple query kindly help me. I have a 2 Table

Edge and Content Table..

Both having a 7 Month Data in different excel.

Edge Table i have Certain Column

Id,

EdgeDate,

IdName,

NoofActiveUser,

NoofRegisteredUser

And in Content i have Certain Column

Id,

ContentDate,

Location,

EligibleUser

so i m connecting both on ID Basis as Primary Key..

But i m creating Master Table and Using EdgeDate Connected with Master Table for Date. and Getting Day , Month , Year.

But on Dashboard if i m searching for any month so i m not getting count of Eligible user based on Month..

so how i connect to ContentDate to Master Calendar...

Kinldy Help Me

Re: How to Connect table with 2 Column

Joaquin_Lazaro — Fri, 30 Oct 2015 15:43:08 GMT

Hello:

Read this Canonical Date ... a very interesting doc of a QV guru

Hope it helps

Joaquín