Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
jleach2
Contributor II
Contributor II

$Field table with measures

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?

$FieldAverageMedianSum
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>

 

Labels (2)
3 Replies
sivakumar1994
Contributor III
Contributor III

Could you please share your data ?

jleach2
Contributor II
Contributor II
Author

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

danilostochi
Creator II
Creator II

https://community.qlik.com/t5/Qlik-Brasil/Pesquisa-de-qualquer-campo-utilizando-Table-e-Field/gpm-p/...
+55(44) 9 9993-3605, WhatsApp
E-Mail or Skype - danilo16stochi@hotmail.com