topic Re: Sorting in Pivot Table in QlikView

Sorting in Pivot Table

Nagaraju_KCS — Thu, 25 Feb 2016 03:27:52 GMT

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

Re: Sorting in Pivot Table

HirisH_V7 — Thu, 25 Feb 2016 03:37:50 GMT

There are two outputs what you need exactly!

Check this,

HTH,

Hirish

Re: Sorting in Pivot Table

Nagaraju_KCS — Thu, 25 Feb 2016 03:39:31 GMT

I want 2 charts and 2 outputs

Re: Sorting in Pivot Table

HirisH_V7 — Thu, 25 Feb 2016 04:00:13 GMT

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

Re: Sorting in Pivot Table

Nagaraju_KCS — Thu, 25 Feb 2016 04:11:10 GMT

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

Re: Sorting in Pivot Table

saurabhwadhwa — Thu, 25 Feb 2016 04:19:11 GMT

Hi ,

PFA Qvw. Hope that helps you.

Regards,

Saurabh

Re: Sorting in Pivot Table

HirisH_V7 — Thu, 25 Feb 2016 04:20:07 GMT

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!

Re: Sorting in Pivot Table

Anonymous — Thu, 25 Feb 2016 04:53:25 GMT

The below link is useful to you

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

Re: Sorting in Pivot Table

settu_periasamy — Thu, 25 Feb 2016 05:23:37 GMT

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

Re: Sorting in Pivot Table

Nagaraju_KCS — Thu, 25 Feb 2016 05:44:44 GMT

PFA,

I have copied source data and output data also

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

Re: Sorting in Pivot Table

Nagaraju_KCS — Thu, 25 Feb 2016 06:01:12 GMT

HI Settu,

Thanks for Response..

Once you clear all.. and check HR in Category field..

i.e not descending Order

Re: Sorting in Pivot Table

settu_periasamy — Thu, 25 Feb 2016 06:25:44 GMT

Can you check it Now,

Re: Sorting in Pivot Table

Anonymous — Thu, 25 Feb 2016 06:37:58 GMT

In sort tab To give the Original or reserved in the load order column