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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-10-19 10:30 AM

Nested Set Analysis with conditions

I need to create a nested set analysis with the following nested If statement, would appreciate any help or ideas.

 

=If([PROVIDER]='ABC' OR 'XYZ' AND [CODE] like '7*','NO',

 

              If([FSC]=61,'NO',             

 

              If ([LOC]='HSP' AND([C_DT]-[S_DT])>3, 'YES',

 

             If([LOC]='DLS'  AND([C_DT]-[S_DT])>45,'YES',

 

              'NO'))))

 

459 Views
0 Likes
1 Reply
sunny_talwar
MVP
MVP
‎2016-10-19 01:05 PM

Why don't you make the change in the script to create a new field with YES and NO values? AFAIK, I think this expression is not the best place to use set analysis.

311 Views