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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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
“Aspire to Inspire before we Expire!”
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
“Aspire to Inspire before we Expire!”
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
“Aspire to Inspire before we Expire!”
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)