Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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