Dates

[niranjana]

Hi

I have two doubts:

1) In Qliksense List box(Filter Pane), how to show only dates between a certain range say from Feb, 20, 2020 to Oct 21,2021 even though the file contains other dates. How to show only a particular range?

2) In Qliksense Bar chart, how to sort the X-axis according to Month Date irrespective of the year. for ex. the dates 02/21/2020, 10/23/2020 ,02/26/2021,should be sorted as 02/21 , 02/26 ,  10/23.

Thanks in advance

[Saravanan_Desingh]

For your first problem, may be try like this in this ListBox expression,

If(Date>='2/20/2020' And Date<='10/21/2021',Date)
Aggr(If(Date>='2/20/2020' And Date<='10/21/2021',Date),Date)

For the second problem, in the Sort expression, try something like,

Date#(Date,'MM/DD')

[niranjana]

Thanks ! got it...