If greater than or equal to but less than or equal to statement

[krissy_s]

Hello

So far I have the following set analysis, but I need the second condition to be >=1, but <=7.

At the moment I only have >=1 as I don't know how to add in "and <=7" without it creating an error.

The set analysis I have so far is as follows:

= If((([MaxExpiryDate]-(Today()))>= 1),'1-7 days','+ 7 days'))

How do I write the condition so MaxExpiryDate is greater than or equal to 1, but less than or equal to 7, please?

Many thanks

[anushree1 · Accepted solution]

Please check if the below links help:

https://community.qlik.com/t5/New-to-QlikView/Between-in-Set-Analysis/td-p/1309787

https://community.qlik.com/t5/QlikView-App-Development/Set-analysis-sum-between-two-given-dates/td-p...