Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

between function

I have table 1

name

date

I concatenated it

name & ' ' & date as name_date //this is a key

I have table 2

name1

datefrom

dateto

____________ as name1_date

Now, what i want is i want to create a key name1_date using concatenate,

in table 1 I have to pick up date and if it exists between datefrom and dateto only then i get the concatenated value of name1_date.

I need to do it in script.

Any directions?

1 Reply
Anonymous
Not applicable
Author

Hi,

Use the inverval match to complete your requirement.

PFA.

Regards,

Chinna