Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
roisolberg
Creator
Creator

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
Creator
Creator
Author

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!

mark6505
Partner
Partner

Hi,

I would read this

Canonical Date

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

Mark

vishalarote
Partner
Partner

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".