Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is the translation into a set analysis expression of this function?

Can someone give me a "translation" into a set analysis expression to this function?


MAX(IF([RSLT: Type]='C' AND [RSLT: Numeric Value]<=MEDIAN(IF([RSLT: Type]='C' AND [RSLT: Numeric Value]<=MEDIAN(IF([RSLT: Type]='C',[RSLT: Numeric Value])),[RSLT: Numeric Value]))))


Greetings,
Iassen

1 Reply
Not applicable
Author

OK, I got the first part fixed:


MAX(IF([RSLT: Type]='C' AND [RSLT: Numeric Value]<=MEDIAN({<[RSLT: Type]={'C'},[RSLT: Numeric Value]={"=[RSLT: Numeric Value]<=MEDIAN({<[RSLT: Type]={'C'}>} [RSLT: Numeric Value])"}>} [RSLT: Numeric Value]),[RSLT: Numeric Value]))


Now the question is, what do I do with the outer part? Because when I bring in a second set of quotes it messes up the syntax. Confused