topic sorting problem in QlikView

sorting problem

Mon, 12 Mar 2012 18:56:53 GMT

Quick question for Experts ,

I have a pivot table with 2 nested rows, Customer_Number & Customer_Name.

What I want to do is sort Cutomer_Name alphabetical. I tried many ways but it does not work.If I put Customer_Number as the second row , it works but when it's in the first row I can not sort the Cstomer_Name alphabetically.

Any idea is appreciated......

Thanks,

Nima

sorting problem

Anonymous — Mon, 12 Mar 2012 22:12:30 GMT

Hi Nima,

I think you can do this by not checking any sort option for the Customer_Number on the Sort tab of the pivot table. For Customer_Name choose Text A-Z.

If you still can't get it done, I think it would be helpfull to upload a demo qv document. In that way we know more specific what you are talking about.

Kind regards,

Henco

sorting problem

jagan — Tue, 13 Mar 2012 08:03:34 GMT

Hi,

Try using the Expression option in sort tab.

Check/Select Expression option and give

=Cstomer_Name

and select Ascending.

Hope it helps you.

Regards,

Jagan.

Re: sorting problem

Tue, 13 Mar 2012 13:25:30 GMT

I have already tried these solutions and did not work

please check the attached.