Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Tags (1)
1 Reply
Not applicable

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

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

Community Browser