Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

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

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

1 Solution

Accepted Solutions
Highlighted
Valued Contributor II

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

1 Reply
Highlighted
Valued Contributor II

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