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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Dnyanesh5559
Contributor
Contributor

regarding expression

Col1_date in between [col2 _date<=15 and col2_date>=1]

I want col1_date between col2_date<=15 and col2_date>=1 this range
Please provide some logic to build.

I am doing this on front side.


if(num#(date(key_date,'DD'))<=15 and  num#(date(key_date,'DD'))>=1,date(NETDUEDATE,'DD-MM-YYYY'),'NULL')

I am trying this one but its showing error

Labels (1)
2 Replies
rubenmarin

Hi, if key_date is a date you can use:

If(Day(key_date)>=1 and Day(key_date)<=15, date(NETDUEDATE,'DD-MM-YYYY'),Null())

Or: Aggr(If(Day(key_date)>=1 and Day(key_date)<=15, date(NETDUEDATE,'DD-MM-YYYY'),Null()),key_date)

Dnyanesh5559
Contributor
Contributor
Author

Thank You so much..