Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
NickBentley
Contributor III
Contributor III

Calculated Dimension - Date Range

Hi,

 

I am trying to make a calculated dimension for a range of weeks (Chron_Week).

 

When I use the IF statement = IF(Chron_Week >40,Chron_Week) it works fine and gives me all Chron_Week's above week 40 but I want the range to be between week 41 and 49.

When I try =IF(Chron_Week >40<50,Chron_Week) it comes back with error in expression. 

Would it be possible for me to put a variable in there with the week range of 41 to 49?

Thanks,

Nick 

 

Labels (1)
1 Solution

Accepted Solutions
anthonyj
Creator III
Creator III

Hi @NickBentley ,

The syntax is like below:

IF(Chron_Week >40 and Chron_Week <50,Chron_Week)

Regards

Anthony

View solution in original post

2 Replies
anthonyj
Creator III
Creator III

Hi @NickBentley ,

The syntax is like below:

IF(Chron_Week >40 and Chron_Week <50,Chron_Week)

Regards

Anthony

NickBentley
Contributor III
Contributor III
Author

Thanks Anthony, your reply got it working.

I noticed the space I was using in between Chron_Week and '<' was causing issues.

Cheers,

Nick