topic Re: Sorting Issue in QlikView

Sorting Issue

upaliwije — Wed, 29 Aug 2018 09:38:23 GMT

Hi Friends

I have folowing pivot Table in my QV doc.

My current output is shown in first statment and required report is shown below. In fact I want to sort my report (branch Column)as per ratio colum under Non_payment catagory. I have tried with follwing expresion in sort tab. But it does not work. Pls help me.

Re: Sorting Issue

Anonymous — Wed, 29 Aug 2018 09:56:49 GMT

does the Pivot table show "NON_PAYMET" instead of "NON_PAYMENT" in MAIN_CATEGORY?

Re: Sorting Issue

upaliwije — Wed, 29 Aug 2018 10:14:52 GMT

Yes Rudolf,

I have made a mistake there. I have corrected it still the report is not what I want .. Pls help

Re: Sorting Issue

Anonymous — Wed, 29 Aug 2018 10:25:51 GMT

can you post qvw?

how Comes that branch A now has total of NOS=49 and Refund2016 = 1666665

in required ouptput branch a has total of NOS=31 and refund2016 = 626387?

no branch Shows the same figures like in your first post

Re: Sorting Issue

upaliwije — Wed, 29 Aug 2018 10:52:28 GMT

Yes What you say is correct. I am not in a position to share the Qv file. If you go by my last report forgetting the earlier one it is sorted on Value Column and not % column. Can you suggest me a way to sort it according to Ratio. Pls help.

Re: Sorting Issue

prieper — Wed, 29 Aug 2018 10:59:05 GMT

Hi,

you only need to repeat (copy & paste) exactly the expression used for the Ratio within the sorting option for BRANCH.

Peter

Re: Sorting Issue

Anonymous — Wed, 29 Aug 2018 11:15:09 GMT

I made a short sample

I defined the sort for Dimension branch to "=sum({<Main_Cat={'Non-Payment'}>}Refund)/sum (total BRANCH> Refund)

it's sorted by Ratio of non-payment