Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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