topic Sorting in QlikView

Sorting

brindlogcool — Mon, 06 Aug 2012 02:11:03 GMT

Hi,

Is it possible to sort based on two columns in qlikview. Consider i have two columns Username and Date.

I want to sort the Username by A- Z and then by date.

I tried the sorting by enabling the sorting of Name and Date , But is not working as expected .

I want if the name is sorted by A-z, it should remain in the same when i am trying to sort by date. but it is not happening. when i click on date it is chaging the name order as well.

Is there any way to get this done in Qlikview

Re: Sorting

kaushiknsolanki — Mon, 06 Aug 2012 05:01:34 GMT

HI,

If you are trying in Pivot table then it will not work, but yes if you convert your chart into straight table it will work.

Regards,

Kaushik Solanki

Re: Sorting

brindlogcool — Mon, 06 Aug 2012 10:56:29 GMT

Thanks for your response. I am using straight table but it is not working.