topic How to get Sorted value? in QlikView

How to get Sorted value?

nachiket_shinde — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have following data

I want Type wise, Max(Month_Number) wise, year wise avg. In this case 8.58006.

What expression should I write for this?

sunny_talwar — Mon, 03 Oct 2016 17:27:09 GMT

Where are you looking to get this, text box object or chart? If it is a chart what all are going to you dimensions?

nachiket_shinde — Tue, 04 Oct 2016 06:32:16 GMT

Want to display in Bar chart Type wise, Max(Month_Number) wise, year wise

nagarjuna_kotha — Tue, 04 Oct 2016 06:53:21 GMT

Ue below exp :

Rate: Sum({<Month_number={'$(=min(Month_number))'}>}Rate)

Avg: Sum({<Month_number={'$(=min(Month_number))'}>}Avg)

Rooling sum : Sum({<Month_number={'$(=min(Month_number))'}>}RollingSum)

I hope this mat helps you.

-Nagarjun

shraddha_g — Tue, 04 Oct 2016 07:24:08 GMT

which chart you are using? what is expected output for this

rajpreeths — Tue, 04 Oct 2016 08:23:17 GMT

You can use expression FirstSortedValue(Avg,-aggr(Avg,Year,Month_number)) for the expected results.

Please refer the attachment and if the result is not as requested then please share dimensions details to be used in the chart.

Rajpreeth S

rajpreeths — Tue, 04 Oct 2016 10:02:37 GMT

Hi ,

I forgot to mention one point,

Type should be added in the aggr expression if you have multiple values for Type field in data model. ( For type wise data)

FirstSortedValue(Avg,-aggr(Avg,Type,Year,Month_number))

Rajpreeth S

sampada0810 — Tue, 04 Oct 2016 10:29:38 GMT

Use a straight table and apply sorting