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

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