topic Re: Get Min, Max, AVG and Median in One Graph? in App Development

Get Min, Max, AVG and Median in One Graph?

Anonymous — Fri, 22 Sep 2017 10:11:17 GMT

Hello Everyone!

How can I get a graph just like the one in Qlik Sense's Data Management Profiling (Data Manager ==> Select Table ==> select pen shaped Icon ==> select any column). it Auto creates a Summary sheet and this sheet has a value range which I'd like to get. Any ideas?

Thanks!

Re: Get Min, Max, AVG and Median in One Graph?

RicardodelaRosaQlik — Fri, 22 Sep 2017 11:03:03 GMT

Hello mate!

The value range area is a group of 4 functions that are applied on the column you select.

You can represent that in different formats (KPIs, Texts...) but the 4 functions are:

Min(column_name)

Max(column_name)

Median(column_name)

Avg(column_name)

For apply this functions you only need to add a measure on the chart you want to use. When you´ll add a measure it will ask you for choose the field you want to use and instead of choose press the function button (that appears as a fx icon) and write all the functions I wrote you above (remember to change the name of the column) and then press apply button.

After add each measure with his own function you will see the values you wanted.

I hope that helps you to get what you wants.

Regards,

Ricardo

Re: Get Min, Max, AVG and Median in One Graph?

Anonymous — Fri, 22 Sep 2017 12:23:43 GMT

Thanks but the attached graph is what I have in mind.

Re: Get Min, Max, AVG and Median in One Graph?

Anonymous — Fri, 22 Sep 2017 12:24:07 GMT