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: 
Not applicable

Master calendar

Hi all,

I have created a master calendar for the date field "campaign_start_date". I have used that date field as filter pane.

In filter pane you can see the dates which is not in order. First it is displaying the date which is in table.

Then it is displaying the other dates.

I have attached the sample data please check and help i need the continuous dates from min date to max date.

As i am using this field to filter the data according to dates or to select data between two dates.

Is their any other date picker object is present to pick the dates?

Thanks,

Pramod

1 Reply
Michael_Tarallo
Employee
Employee

Hi Pramod,

I looked over the calendar, it seems correct. One thing I noticed is that you are loading from resident campaignmetrics, in your script - but I don't see the table tag campaignmetrics: entered before your data load, which makes me believe you are not getting the actual or newly created date and it shows the original date field:

try this and reload.

....

.....

....

campaignmetric:

LOAD `batch_meta_data_id`,

    `campaign_metrics_id`,

    date(floor(campaign_start_date),'MM-DD-YYYY') as campaign_start_date,

    date(floor(campaign_end_date),'MM-DD-YYYY') as campaign_end_date,

    `landing_page_hits`,

    `sign_up`,

    completions;

SQL SELECT `batch_meta_data_id`,

      `campaign_metrics_id`,

      `campaign_start_date`,

    `campaign_end_date`,

    `landing_page_hits`,

    `sign_up`,

    completions

FROM rcdbrpt.campaignmetrics;

I also attached my example - that does have the missing dates.

Understanding the Master Calendar (video)

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik