topic Re: Sorting order in QlikView

Sorting order

upaliwije — Mon, 27 Nov 2017 04:50:54 GMT

Hi Friends

I have following Pivot Table which I am unable to sort in the order I want

I want it to be sorted on the column BCOD by the Avg_bud_per_month and the result should be like shown belo

My expression for Avg_bud_per_month is BUDGET_2018/12 But when I apply it to sort order it does not work Pls help

Re: Sorting order

prma7799 — Mon, 27 Nov 2017 05:07:40 GMT

Put Avg_bud_per_month expression in sort as desc

Re: Sorting order

pradosh_thakur — Mon, 27 Nov 2017 05:19:31 GMT

hi put the expression in the sort tab if it doesn't help post the sample document here.

Re: Sorting order

upaliwije — Mon, 27 Nov 2017 05:48:14 GMT

I have already done it

Re: Sorting order

Anil_Babu_Samineni — Mon, 27 Nov 2017 05:49:30 GMT

Which version you are using? And can you paste expression you worked for

Re: Sorting order

upaliwije — Mon, 27 Nov 2017 06:19:55 GMT

Version =11

my expression

Sum({$<NOTE = {'515','516','602','603','604','612','642','702','704','708','711','712','715','513','517','605','610','611','615','616','618','703','719','722'}>}BUDGET)/12

Re: Sorting order

Anil_Babu_Samineni — Mon, 27 Nov 2017 06:27:05 GMT

Certain period of version limitations works only for Column level to each not separate. I assume, I will think this if more that 12+ versions will work expression data point level.

=Aggr((Sum({$<NOTE = {'515','516','602','603','604','612','642','702','704','708','711','712','715','513','517','605','610','611','615','616','618','703','719','722'}>}BUDGET)/12),(TERRITORY_DESC,(=(Sum({$<NOTE = {'515','516','602','603','604','612','642','702','704','708','711','712','715','513','517','605','610','611','615','616','618','703','719','722'}>}BUDGET)/12),(NUMERIC,DESCENDING))))

Note - Try to attach application to work rather thinks if available.