Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

Link calendar to table

Hiya

i am using the following calendar...

Calendar: DECLARE FIELD DEFINITION TAGGED '$date' Parameters first_month_of_year = 1 Fields

     Year($1) As Year Tagged '$year',

     Month($1) as Month Tagged '$month',

     Date($1) as Date Tagged ('$date', '$day'),

     Week($1) as Week Tagged '$week',

     Weekday($1) as Weekday Tagged '$weekday',

     DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear Tagged ('$numeric');

DERIVE FIELDS FROM FIELDS [Date_Received] USING Calendar;

i need to link Weekday from this calendar to my main Orders table. is there a way to do this please?

Kind Regards

Joeybird

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Link calendar to table

The only thing you need to do is to create Weekday field in the Order table.  For example, if you have OrderDate field, you can use this:

Weekday(OrderDate) as Weekday

2 Replies
mov
Esteemed Contributor III

Re: Link calendar to table

The only thing you need to do is to create Weekday field in the Order table.  For example, if you have OrderDate field, you can use this:

Weekday(OrderDate) as Weekday

joeybird
Contributor II

Re: Link calendar to table

Hiya

fab xx

Thank you

Kind Regards

Joeybird