topic date comparison based on user entry in QlikView

date comparison based on user entry

Anonymous — Thu, 08 Nov 2018 17:39:42 GMT

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 Get field selection for capturing the user entry and compare the values .It didn't work.

Advance Thanks for your help.

el_aprendiz111 — Thu, 08 Nov 2018 21:29:31 GMT

Hi,

1 option:

IF(Date1 <= EntryDate and Date1 >= DueDate, Name)

sergio0592 — Thu, 08 Nov 2018 21:44:35 GMT

Hi,

Create a variable (Value in my exemple) in your input box and add in a text box :

=Concat(distinct Aggr(If(EntryDate<=$(Value) and DueDate>=$(Value),Name), Name),'/')

See my attached .qvw

Is it what you're trying to achieve?