Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
roisolberg
New Contributor III

Switching between 2 date sets

Hi Everybody,

In my model i have  2 sets of dates, 'CreationDate' and 'OperationDate'

I have created 2 master calendars for each date set.

I am trying to find an extension or any other solution that i can choose for example creation date and it will select only the dates related for creation date.

I have tried using Field UI extension but it seems to be working only for measures.

Any ideas?

Thanks,

Roi

3 Replies
roisolberg
New Contributor III

Re: Switching between 2 date sets

Hi All,

i will explain a bit better with an example.

this is what i have tried to do:

i've set two fields that will be used as buttons:

1.JPG

then i defined a variable

2.JPG

and i used a Field UI extension in order to chose the selected date set:

(the date filters are connected to the variable =$(vYear) )

‏‏לכידה.JPG

and now i want to chose dates that will reflect on the selected date set (in this example 'Creation Date')

but when i chose a year, the selections get mixed all together:

3.JPG

i want the chosed date type to be the leading date for the model.

if possible it could also be only 1 column that is changing between the date types or it could be like the example with 2 fields, a solution of any kind would be great..

Thanks!

Partner
Partner

Re: Switching between 2 date sets

Hi,

I would read this

Canonical Date

This is how i approach the problem, without using multiple calendars.

Mark

Partner
Partner

Re: Switching between 2 date sets

Load

Creation_Date as Date,

'Creation' as DateFlag

from table1;

concatenate

Load

Operation_Date as Date,

'Operation' as DateFlag

from table2;

Then Create Date Calendar which basis of "Date".