Sorting

[brindlogcool]

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

[kaushiknsolanki]

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

[brindlogcool]

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