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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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