Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_testing
Specialist II
Specialist II

Sorting in Pivot Table

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:    

CategoryNameTechnologyRating

Operations

DeepakQlikview5
PaulQlikview4
RameshQlikview3
SaiTableau4
SantuTableau3


OutPut2:  

Operations

DeepakQlikview5
PaulQlikview4
SaiTableau4
SantuQlikview3
SantuTableau3

OutPut1 is Technology wise Ascending Order

OutPut2 is Rating wise Ascending Order

PFA,

Hope you Understand..

Thanks in Advance...

12 Replies
HirisH_V7
Master
Master

There are two outputs what you need exactly!

Check this,

Sort.PNG

HTH,

Hirish

HirisH
qv_testing
Specialist II
Specialist II
Author

I want 2 charts and 2 outputs

HirisH_V7
Master
Master

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

HirisH
qv_testing
Specialist II
Specialist II
Author

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
Partner - Contributor III
Partner - Contributor III

Hi ,

PFA Qvw. Hope that helps you.

Regards,

Saurabh

HirisH_V7
Master
Master

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!
HirisH
Anonymous
Not applicable

settu_periasamy
Master III
Master III

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..

Capture.JPG

qv_testing
Specialist II
Specialist II
Author

PFA,

I have copied source data and output data also

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