Qlik Community

Qlik Sense App Development

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

Not applicable

Qlik Sense Desktop - how can I filer by date?

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

1 Solution

Accepted Solutions
Employee
Employee

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

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.Capture.PNG.png

Capture2.PNG.png

3 Replies
Employee
Employee

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

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.Capture.PNG.png

Capture2.PNG.png

Not applicable

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

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

Employee
Employee

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

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/DateAndTimeFunc...

Community Browser