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: 
Not applicable

Multiple if statements, trying to add logic

If A1 Date >= 1 and A2 date >= 1 then do one of the following

If A1 date <= A2 date show A1 date-setup, else show A2 date-setup date, else

If A1 date >= 1 then A1 date-setup date, else

If A2 date >=1 show A2 Date-setup date, this will show the data date – setup date

            if( (len(trim([First A1 Date]))>=1 and len(trim([A2 Date]))>=1),
                    
if( [First A1 Date] <= [A2 Date], ( [First A1 Date]-[Setup Date] ), ( [A2 Date]-[Setup Date] ) ),             
                    
if( len(trim([First A1 Date])) >=1, ( [A1 Date]-[Setup Date]),
                    
if(len(trim([A2 Date]))>=1, ( [A2 Date]-[Setup Date] ), ( [Data Date]-[Setup Date] ) ) ) ) as [Age_Setup]  ,

I know want to add in the B1 Date and B2 date and give it the exact same logic as A1 and A2  Here is what I have done so far                                                                                        

if( (len(trim([First A1 Date]))>=1 or len(trim(First B1 Date]))>=1 and len(trim([A2 Date]))>=1 or len(trim([B2 Date]))>=1),
                    
if( [First A1 Date] <= [A2 Date], ( [First A1 Date]-[Setup Date] ), ( [A2 Date]-[Setup Date] ) ),

                  if( [First B1 Date] <= [B2 Date], ( [First B1 Date]-[Setup Date] ), ( [B2 Date]-[Setup Date] ) ),
                   
if( len(trim([First A1 Date])) >=1, ( [A1 Date]-[Setup Date]),

             if( len(trim([First B1 Date])) >=1, ( [B1 Date]-[Setup Date]),


 
if(len(trim([A2 Date]))>=1, ( [A2 Date]-[Setup Date] ), ( [Data Date]-[Setup Date] ) ) ), if(len(trim([B2 Date]))>=1, ( [B2 Date]-[Setup Date] ), ( [Data Date]-[Setup Date] ) ) ),  ) as [Age_Setup]  ,

I am having issues with my brackets based on this logic.  The last bracket should encompass everything beginning with the first if statement

0 Replies