Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date Tables with duplications

Hi

I have 40 areaswithin my organisation and I have 2 Billing cycles.  Some areas are on cycle 1 and others on cycle 2.

Each cycle has a publish date which is 56 days following the previous publish date.  However both cycles original cycle start date are different.  i.e.  Cycle 1 started on 04/02/13 for 8 weeks, and cycle 2 started on 18/02/13 for 8 weeks

I have created a report which shows the billing date for the customer, however I want to show if the date is published based on todays date.  I have created a table which shows which cycle each area is on based on the billing date, however this will hold duplications as there is more than one cycle. e.g. the table for my billing cycles will have 2 seperate rows for each cycle publish date .

The problem I have is that I only have the following fields to link

Table 1 - Bill amount

Billing date

Billing amount

Customer Ref (PK link)

Table 2 - Customer

Customer Ref (FK Link)

Customer name

Table 3 - Division member

Customer Ref (FK Link)

Division Name (PK Link)

Table 4 - Cycle

Cycle Name (PK Link)

Division Name (FK Link)

Table 5 - Cycle Dates

Billing date

Cycle Name (FK Link)

Publish date

Cycle start date

Cycle end date

When I link table 5, I get a duplication as there are 2 rows with the same Billing date.

I am sure there is a simple solution.

Please help

Thanks

Phil

1 Reply
fernando_tonial
Partner - Specialist
Partner - Specialist

Hi, You can try formating the field Billing date.

Date(Floor(Billing date)) As [Billing date]

Best Regards.

Tonial.

Don't Worry, be Qlik.