Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik sense experts
I wanna count the number of contract on the next day and from day 2 to day 7,day 8 to day 30 and etc with the date start is today (4/6/2019). Can someone help me with this? I sincerely appreciate your effort and kind assistance.
Contract No | Date |
10719227 | 06/12/2017 |
10664916 | 02/12/2018 |
10270315 | 15/11/2018 |
9950188 | 01/05/2018 |
9983190 | 01/11/2018 |
10176700 | 08/11/2018 |
10777992 | 08/12/2018 |
10325880 | 18/11/2017 |
10842487 | 16/12/2018 |
10293569 | 17/11/2018 |
10439690 | 01/09/2018 |
10576281 | 01/12/2019 |
10435623 | 01/06/2017 |
10368401 | 01/12/2018 |
10136630 | 04/11/2018 |
11004747 | 19/06/2018 |
10941872 | 19/12/2018 |
10592878 | 13/12/2019 |
11127129 | 01/01/2019 |
10402093 | 18/04/2018 |
11024282 | 01/01/2019 |
11125790 | 01/04/2019 |
10413789 | 01/12/2018 |
10164752 | 01/12/2018 |
10200464 | 10/05/2018 |
10661803 | 01/03/2019 |
10675903 | 05/12/2018 |
10851409 | 14/02/2018 |
10201292 | 08/01/2018 |
10097252 | 01/11/2017 |
11099194 | 01/01/2020 |
10425944 | 01/12/2018 |
10824499 | 12/03/2019 |
10509570 | 01/07/2018 |
10838976 | 14/12/2018 |
9898805 | 01/11/2017 |
10977178 | 17/12/2018 |
10621777 | 01/12/2018 |
10101639 | 01/11/2018 |
11086296 | 01/01/2019 |
10874489 | 16/12/2017 |
10001031 | 01/11/2018 |
10163108 | 07/11/2018 |
10792087 | 09/12/2018 |
10297375 | 15/11/2018 |
11111404 | 01/04/2018 |
10666938 | 01/12/2018 |
10924015 | 19/12/2018 |
9957965 | 01/11/2017 |
11023269 | 20/12/2018 |
10564260 | 01/06/2019 |
9993780 | 01/05/2019 |
10972243 | 01/01/2019 |
9786435 | 01/11/2018 |
10641672 | 01/12/2018 |
10117404 | 02/11/2018 |
10839227 | 13/07/2018 |
11078525 | 01/01/2019 |
10864897 | 16/12/2018 |
10582973 | 05/12/2018 |
11110585 | 01/03/2018 |
10421887 | 18/11/2018 |
10460678 | 01/12/2019 |
10374619 | 17/11/2018 |
10006930 | 01/11/2018 |
10371970 | 16/05/2019 |
11094255 | 01/01/2019 |
10407035 | 01/12/2018 |
10002817 | 01/02/2018 |
10571936 | 01/12/2018 |
10368363 | 01/12/2019 |
10438282 | 19/11/2018 |
10154851 | 10/11/2017 |
10504067 | 01/12/2018 |
@Channa : already found the problem for my data set. The format of date field is 'M/D/YYYY' that why i need to use the function date with format reference. This is my expression: count({<Date={"$(=date(today(),'M/D/YYYY'))<=$(=date(today()+30,'M/D/YYYY'))"}>} contract No). Thank you for your suggestion and have a nice day.
=Count({$<Date={"<=$(=Date(Today(),30))>=$(=date(Today(),0))"}>}ContractNo)
this will bring upcoming 30 days contracts
@Channa : i try your expression but it doesn't work.
you source file date format has some problem
find the attach
=Count({$<Date={"<=$(date(Date(Today(),30),'DD/MM/YYYY'))>=$(date(Date(Today(),0),'DD/MM/YYYY'))"}>} distinct Contract)
i change the source
please find the xls...ur source has showing nulls
@Channa : already found the problem for my data set. The format of date field is 'M/D/YYYY' that why i need to use the function date with format reference. This is my expression: count({<Date={"$(=date(today(),'M/D/YYYY'))<=$(=date(today()+30,'M/D/YYYY'))"}>} contract No). Thank you for your suggestion and have a nice day.