topic Re: Filter field in App Development

Filter field

Arianna1 — Sat, 16 Nov 2024 17:57:34 GMT

Hello world,
I would be happy if you could help me with the following request:
From a field of date (see Example: 01/09/2020, 02/09/2020, ecc), I would build a filter where the
choices are: month, week, day.
Thanks in advance for an possible answer.

Arianna

Re: Filter field

Taoufiq_Zarra — Sat, 17 Oct 2020 08:51:14 GMT

@Arianna1

are you looking for

Month(Date)

Year(Date)

Week(Date)

Day(Date)

Re: Filter field

Arianna1 — Sat, 17 Oct 2020 09:01:01 GMT

Hi Taoufiq,

thanks for the reply but the functions you are talking about, for example Month(Date) used in a filter, it will have the choices: january, february, march, april, ecc.

I would build a filter with the choices: month, week, day.😀

Re: Filter field

Matthewli — Sat, 17 Oct 2020 10:23:47 GMT

I'm making a project schedule for our construction company.

I would like to be able to have a filter that only shows "Start Date" that is equal to this week or this month.

Is that possible?

Re: Filter field

Vegar — Sun, 18 Oct 2020 06:27:22 GMT

As the same date can be associated with both year, month, week and day you need to create a new table that holds these connections.

You could do something like this. Adjust it to your data model and needs.

Periods:
Load
Date,
'today' as Period
From SourceContainingDates
Where
Date= today() ;

Concatenate (Periods) Load
Date,
'WTD' as Period
From SourceContainingDates
Where
inWeekToDate ([Date] , today() , 0);

Concatenate (Periods) Load
Date,
'MTD' as Period
From SourceContainingDates
Where
inMonthToDate ([Date] , today() , 0);

Concatenate (Periods) Load
Date,
'YTD' as Period
From SourceContainingDates
Where
inyeartodate ([Date] , today() , 0);

Re: Filter field

rwunderlich — Sun, 18 Oct 2020 16:27:14 GMT

In the Recipes section of QlikCookbook, download the "Date Grouping" example. There you'll find scripting to assign named ranges to your dates.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Filter field

Arianna1 — Mon, 19 Oct 2020 10:08:31 GMT

Thank you all but Rwunderlich this is exactly what I was looking for.

Thank you. Have a good day