topic Re: Qlik Sense Desktop - how can I filer by date? in App Development

Qlik Sense Desktop - how can I filer by date?

Tue, 21 Oct 2014 14:34:28 GMT

I am very new to qlik.

I have a list of sales with order_date (format dd:mm:yyyy hh:mm). I would like to filter them by month. Any suggestions how can I do that in a simple way? I am not able to write complex script at the moment.

Cheers,

Alessandro

Re: Qlik Sense Desktop - how can I filer by date?

JonnyPoole — Tue, 21 Oct 2014 18:49:12 GMT

Try creating a dimension with the expression

Month( [order_date])

Then you can drag the dimension onto the grid and its ready for filtering

also consider

MonthName( [order_date])

for another dimension...in fact you can format the months however you wish.

Re: Qlik Sense Desktop - how can I filer by date?

Wed, 22 Oct 2014 06:22:57 GMT

Thanks! This was very useful. Do you have a list of all/similar functions to Month which I can use? For example it could be very useful for me to check also quarters or day of the week when orders happen. Perhaps there are functions ready for this

Re: Qlik Sense Desktop - how can I filer by date?

JonnyPoole — Wed, 22 Oct 2014 14:23:06 GMT

There is a list of date functions in the Help file that lists all of them.

One function that is very helpful is the date() function . You can format the result for the screen how you wish..

ex:

date( [order_date] , 'YYYY-MMM') -> 2014-Apr etc...

date( [order_date], 'WWWW') -> Monday , Tuesday etc....

http://help.qlik.com/sense/en-US/online/#../Subsystems/WorkingWith/Content/Scripting/DateAndTimeFunctions/DateAndTimeFunctions.htm?Highlight=date