topic Re: Sorting the values as per fixed sequence. in QlikView

Sorting the values as per fixed sequence.

Wed, 25 Nov 2020 16:16:04 GMT

We have a pivot table report where data is showing as attached, we need to see the data in the attached sequence.

Re: Sorting the values as per fixed sequence.

dsharmaqv — Thu, 16 Mar 2017 11:23:42 GMT

looks like alphabetical order

properties > sort > select Text A->Z

Re: Sorting the values as per fixed sequence.

neha_shirsath — Thu, 16 Mar 2017 11:25:09 GMT

Hi Ravindra,

Pivot table doesn't support the attractive sorting.

But Could you please provide your file for more details.

Thanks,

Neha

Re: Sorting the values as per fixed sequence.

ramasaisaksoft — Thu, 16 Mar 2017 11:28:41 GMT

Hi Ravi,

For a list box we have only specified orders only those are available in Properties-->Sort

I hope you are asking Load order so select that one.(Remove all checks and select only Load order)

we don't have custom order option.

if you feel you got solution for your issue,please close the thread by clicking "Correct Answer"

Re: Sorting the values as per fixed sequence.

Thu, 16 Mar 2017 11:28:53 GMT

Hi Deepak,

Sorting is done same as your comment.

Thanks,

Ravindra

Re: Sorting the values as per fixed sequence.

Thu, 16 Mar 2017 11:33:01 GMT

Hi Rama,

Your solution changes the order but not as requested by user.

Thanks,

Ravindra

Re: Sorting the values as per fixed sequence.

avinashelite — Thu, 16 Mar 2017 11:33:37 GMT

Create a inline table and define your sort order and then go to your pivot table >Sort>expression > and choose your sort order column

e.g

LOAD * inline

[

Description,Description_Sort

Fe,1

So,2

...

...Etc

];

In the sort expression use the Description_Sort and check the ascending order

Hope this helps you

Re: Sorting the values as per fixed sequence.

rahulpawarb — Thu, 16 Mar 2017 11:38:41 GMT

Hello Ravindra,

If Description field has limited values then use below expression under Sort by Expression:

If(Description='Fe', 1, If(Description='SiO2', 2, If(Description='AI2O3', 3, If(Description='P', 4, If(Description='Mn', 5, If(Description='CaO', 6, If(Description='MgO', 7, If(Description='K2O', 8, If(Description='LOI', 9, If(Description='MOISTURE', 10, If(Description='SIZE:+0.149 MM', 11, 12)))))))))))

Hope this will be helpful.

Regards!

Rahul

Re: Sorting the values as per fixed sequence.

Thu, 16 Mar 2017 11:47:51 GMT

Hi Rahul,

Your solution changes the order but not as requested by user.

Thanks,

Ravindra

Re: Sorting the values as per fixed sequence.

Thu, 16 Mar 2017 11:57:23 GMT

Hi Avinash,

Your solution changes the order but not as requested by user.

Thanks,

Ravindra

Re: Sorting the values as per fixed sequence.

rahulpawarb — Thu, 16 Mar 2017 12:08:49 GMT

Hello Ravindra,

Could you please share the application with sample data? This will help us to provide expected response.

Regards!

Rahul

Re: Sorting the values as per fixed sequence.

dsharmaqv — Thu, 16 Mar 2017 12:10:40 GMT

Hi Ravindra

Please post you app ..... Avinash solution should work. Loks like you are not applying correctly.