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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

How to write a nested if condition

Hi,

I have to write a if condition expression in front end. 

Currently my expression for 'Contract' dimension is :-

if([End date] > '$(vDynamicenddate)' or isnull(End date),'Contract','out of scope')

I have to add another condition in this same expression where

Contract end date < '$(vDynamicenddate)','Contract','out of scope')

so both condition should fill for this 'Contract' dimension:-

if [End date] > [Period end date] and Contract end date < [Period end date]  here vDynamicenddate='Period end date'

 

I tried to write the expression but it's not working as expected, please help

0 Replies