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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
rathnam_qv
Creator
Creator

Replace BETWEEN conditioin in qlik?

Hi All,

i am using the following condition in qlik. but we BETWEEN condition will not work in Qlik.

where LOCAL_CURRENT_MONTH BETWEEN LOCAL_CURRENT_MONTH-3 AND LOCAL_CURRENT_MONTH;

Can any one help me on this.

Thanks,

Rathnam.

1 Reply
jsnova
Partner - Contributor II
Partner - Contributor II

fabs(LOCAL_CURRENT_MONTH - (LOCAL_CURRENT_MONTH-3))