Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jumiprado
New Contributor III

Help with dates!

Hi!

I have the following problem:

I have a table for Clients_ID, each Clients_ID have different amount of certificates listed, for ex.

Client_ID 1 have 5 Certificates so i can create CLIENT_ID as a KEY and CLIEND_ID_CERTIFICATE like 1-1, 1-2, 1-3, 1-4 and 1-5

For each CLIENT_ID I have a Suscribe_Date and for each Certificate I Have other Suscribe_Certificate_Date.

Also i have Billing and Collections table with Billing_Date and Collection_Date.

I have Client_ID for Billing and Collections tables and Billing_ID for each tables too. So I can make a relationship between all the tables with Client_ID   as Key Field. And make a relationship between Billing and Collections with CLIENT_ID_BILL_ID as a Key Field only for those tables.

I create a MasterCalendar for each table (Clients, Certificate, Billing and Collections) and a CommonCalendar with the intention of make a MonthYear to create a line chart for view the evolution of Billing and Collections but when i Use the Common MonthYear values are multiplied.

THANKS YOU!

error.PNG

mindaugasbaciusrwunderlich

Community Browser