Sorting in Pivot for 2 dimension - Qlik Community

vikasmahajan · ‎2014-09-18

Dear all

I have attached format report which is in pivot table I Want to show Highest Division target wise ( I.e. Warren Should come first) and

then sorting on annual target .

It is urgent please share your experience.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2014-09-18

Hi Vikas,

Pls go to Chart properties -> Sort Tab -> Check Expression from Sort By (For Dimension Division)

-> use Sum([Annual Target]) Code and select Descending ->Apply

Thanks

vikasmahajan · ‎2014-09-18

Kunal thanks for reply actually I have done this but not able to get desire sorting.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2014-09-18

Vikas, I am geeting this type of sorting applying the same sorting chriteria.

Is that what you are looking for?

vikasmahajan · ‎2014-09-18

I have also getting same thing in excel when i try in test environment but live scanario is giving me wrong result let me check whether there is problem in source data !

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.