Solved: Sort Order - Qlik Community

upaliwije · ‎2017-09-12

Hi Friends

I have following Pivot table in my doc

I want to Total Column come to the bottom of table and Dept 1 & Dept 2 to remain as it is. The sorting order is

sum(PREMIUM) descending

Further I have a calculated dimension as shown below

=pick(Dim,DEPT,'TOTAL')

Pls help me

sunny_talwar · ‎2017-09-13

Check with this

RangeSum(Only({1} DimF), -sum({<RISK_YEAR = {$(=Max(RISK_YEAR))},RISK_DATE={$(vP17)}>}PREMIUM)/1e10)

sunny_talwar · ‎2017-09-12

Sort this dimension using this expression:

Only({1} Dim)

upaliwije · ‎2017-09-12

still no change Same result

sunny_talwar · ‎2017-09-12

Did you sort this calculated dimension (=pick(Dim,DEPT,'TOTAL')) using this -> (Only({1} Dim)) on the sort tab?

upaliwije · ‎2017-09-12

Yes Sunny

kaushiknsolanki · ‎2017-09-12

Change Descending to Ascending.

Also mark the Text checkbox and see if it works.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

upaliwije · ‎2017-09-12

Then Total comes in between Dept

kaushiknsolanki · ‎2017-09-12

Uncheck the sorting order for Description and check.

If that also doesnt work then please share the sample data to understand it in detail.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

sunny_talwar · ‎2017-09-12

Try this

RangeSum(Only({1} Dim), Rank(DEPT))

and sort ascending

If that doesn't work, try this

RangeSum(Only({1} Dim), -Rank(DEPT))

and sort ascending

upaliwije · ‎2017-09-13

I have tried that but still not working. I have attached my sample data pls advise

Sort Order