Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Multiple IF statements expression

Hi guys, need some help here with if statement logics.    

i have 2 date fields    

1. createdDate  

2. BookingDate    

conditions 

1. createdDate should be lesser than BookingDate

2. createdDate to BookingDate range must not be more than 1 year.    

How do i achieve this? need help cause am newbie here

3 Replies
Highlighted
Partner
Partner

Not sure i understand any deeper complexity but taking your post at face value

if(BookingDate-createdDate>365,'More than a year','Less than a year')

Highlighted
Specialist
Specialist

Are you trying to achieve this in the layout or the Datamodel?

i.e. Are you trying to restrict the data in the load itself or in the chart?

Highlighted

What if conditions and what output you are expecting in the parameters?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)