topic Re: Dates in App Development

Dates

niranjana — Sat, 16 Nov 2024 00:26:24 GMT

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

Re: Dates

Saravanan_Desingh — Sun, 14 Mar 2021 15:58:43 GMT

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')

Re: Dates

niranjana — Tue, 16 Mar 2021 05:32:02 GMT

Thanks ! got it...