Median Function: where to start learning how to add functions to QlikSense

[#1]

Hello All,

I am new to Qlik and trying to find documentation on how to effectively apply median function.

Where should I begin?

Thank you,

Jens

[#2]

more explicitly:

  1)  Where can I find documentation that can define the following terms?

      num Median ({ {SetExpression} {TOTAL [< fld ExpressionFieldRef {,fld ExpressionFieldRef } >]] } expr Expression)

and

  2)  Where can I find these functions pre-written (instead of having to transcribe them from the mouseover comments)?

[NickHoff]

Press F1 for the help menu and use the index or search.

[#4]

F1 doesn't seem to function in QlikSense.

In any of the screens/windows/sections.

[#5]

Are there any other resources available that I can consult for how to construct Median functions in my charts?

There is a cluster of extra code that referenced I am not sure what. For example:  "aggr(sum({1<[IND] ={'I'}>}IM), [Exchange]))"

Is there somewhere I can discover what these all mean and find a way to apply the median function to my absurdly simple chart?

Best regards,

Jens

[#6]

{sound of crickets chirping}

{Background noise of all the videos here:QlikView Free Training - Business Intelligence (BI) Reporting Software Solutions | Qlik being watched in turn.}

{Sound of rifling through all the documentation for qlikview here: Qlikview 10 SR4 Reference Manual}

Well then, how about this?

Syntax for Sets

Hence, the full syntax (not including the optional use of standard

brackets to define precedence) is

• set_expression ::= { set_entity { set_operator set_entity } }
• set_entity ::= set_identifier [ set_modifier ]
• set_identifier ::= 1 | $ | $N | $_N | bookmark_id | bookmark_name
• set_operator ::= + | - | * | /
• set_modifier ::= < field_selection {, field_selection } >
• field_selection ::= field_name [ = | += | –= | *= | /= ]
• element_set_expression
• element_set_expression ::= element_set { set_operator element_set }
• element_set ::= [ field_name ] | { element_list } | element_function
• element_list ::= element { , element }
• element_function ::= ( P | E ) ( [ set_expression ] [ field_name ] )
• element ::= field_value | " search_mask "

[#7]

Jens,

Did you find more about using the Median function in Qlik Sense?

I want to create a measure in Qlik Sense 3.0 using the median function.

Thanks,

Neil

[Anonymous]

Hello Neil,

As it turns out,

and as a more proficient user showed me (though it was left completely out of the manuals at the time)

all one needs to do is use `median()` just as one would use `mean()`.

Oy vey.