Qlik Community

App Development

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

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
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