Sorting in Pivot Table

[qv_testing]

Hi Community,

I am facing one sorting problem in Pivot Table..

I have 3 dimension, and one expression..

I am showing Category--->Name----> Technology  wise rating.

My output should be Ascending Order

OutPut1:    

Category	Name	Technology	Rating
Operations	Deepak	Qlikview	5
	Paul	Qlikview	4
	Ramesh	Qlikview	3
	Sai	Tableau	4
	Santu	Tableau	3

OutPut2:  

Operations	Deepak	Qlikview	5
	Paul	Qlikview	4
	Sai	Tableau	4
	Santu	Qlikview	3
	Santu	Tableau	3

OutPut1 is Technology wise Ascending Order

OutPut2 is Rating wise Ascending Order

PFA,

Hope you Understand..

Thanks in Advance...

[HirisH_V7]

There are two outputs what you need exactly!

Check this,

HTH,

Hirish

[qv_testing]

I want 2 charts and 2 outputs

[HirisH_V7]

As i can see there is no perfect match with your Fields .As of Your mentioned  example and your app.Check this,

[qv_testing]

HI Hirish,

Thanks for Quick response....

You did here manually using Match function.. But i have various Categories

I given just sample example for Operation,

Hope you understand ....

[saurabhwadhwa]

Hi ,

PFA Qvw. Hope that helps you.

Regards,

Saurabh

[HirisH_V7]

Hi ,

• I think you can go with one field sort order which should be in correspondence with Each other .

• Can you tell me your exact one or two requirement ! As like what order you require!

[Anonymous]

The below link is useful to you

Creating a custom sort order - The Qlik Fix! The Qlik Fix!

[settu_periasamy]

Hi,

Check the Attachment.. You can try with Concat and Match function..

Concat will generally give the sorted value. I created one variable and applied it..

[qv_testing]

PFA,

I have copied source data and output data also

In that 2 sheet (Source Data and Output Sheet's)