Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Employee
Employee

Re: Master calendar

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
Community Browser