topic Re: $Field table with measures in App Development

$Field table with measures

jleach2 — Sat, 16 Nov 2024 05:35:09 GMT

I would like to create a chart in the front-end that has some summary statistics on each field and is reactive to user selections.

I know how to do $Field and $FieldNo in a table to produce a list of fields. However, I am having trouble adding measures to the table that evaluate on each field.

Does anyone know how to make something like below?

$Field	Average	Median	Sum
Field1	<average of values in Field1>	<median of values in Field1>	<sum of values in Field1>
Field2	<average of values in Field2>	<median of values in Field2>	<sum of values in Field2>
Field3	<average of values in Field3>	<median of values in Field3>	<sum of values in Field3>

Re: $Field table with measures

sivakumar1994 — Fri, 14 Jun 2019 16:28:38 GMT

Could you please share your data ?

Re: $Field table with measures

jleach2 — Fri, 14 Jun 2019 16:32:35 GMT

This should be able to work with any dataset. $Field is a system field.

Re: $Field table with measures

danilostochi — Fri, 14 Jun 2019 17:21:52 GMT

https://community.qlik.com/t5/Qlik-Brasil/Pesquisa-de-qualquer-campo-utilizando-Table-e-Field/gpm-p/1569946#M56473