Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jaya1998
New Contributor

date comparision based on user entry

I have to compare 2 dates and get the result

User will enter the Date1  : 02/05/2018

                                                                 

EntryDate  DueDate Name

01/05/18 02/03/18 aaaaa

01/06/18 02/06/18 bbbb

01/15/18 05/20/18 cccc

01/30/18 06/06/18 ddddd

02/02/18 08/07/18 eeee

02/04/18 06/22/18 fffff

03/06/18 05/02/18 dsesd

05/06/18 09/09/18 mmmm

05/23/18 01/04/19 rrrrrr

06/22/18 04/04/19 ttttttt

06/25/18 09/09/20 ssssss

I have to find which name belongs to this below condition if the user enter the  Date1  : 02/05/2018

         

Entry Date <= Date 1 

Due Date >= Date 1 

                  

what is the best way to handle.I tried with Getfield selection for capturing the user entry and compare the values .It didn't work.

Advance Thanks for your help.

1 Reply

Re: date comparision based on user entry

GetFieldSelection() Work only when some selections selected. Where USER is entering?