topic Re: How to sort Expression value in Pivot Table in QlikView

How to sort Expression value in Pivot Table

sarfaraz_sheikh — Tue, 20 Jan 2015 14:34:17 GMT

Dear All,

How i can sort the pivot table expression value wise .........I tried but unable to achive the same ..

Sarfaraz

Anonymous — Tue, 20 Jan 2015 14:36:06 GMT

Can you attach the sample file

nirmalraj_kj — Tue, 20 Jan 2015 14:36:41 GMT

Can you post the sample

sarfaraz_sheikh — Tue, 20 Jan 2015 14:57:21 GMT

Dear All,

Please find the attached QVW . I want to sort the data RCA wise .

Please have the look.

Sarfaraz

sarfaraz_sheikh — Wed, 21 Jan 2015 05:52:02 GMT

Dear All,

Kindly suggest any solution for the above post.......it is important.

Sarfaraz

avinashelite — Wed, 21 Jan 2015 06:52:46 GMT

Please find the attachment for the solution:

solu: go to sort tab>select Expression and use =count(DISTINCT {$<DISP_CATEGORY={'*'},SUB_VERTICAL_DESC={'AUTO'} >} SI_NO)

this will do

krishna20 — Wed, 21 Jan 2015 07:34:28 GMT

Hi,

PFA, Hope this helps

Regards

Krishna

Anonymous — Wed, 21 Jan 2015 08:41:02 GMT

In sort tab - Select first dimension and enable sort by Y-Value Ascending/Descending.

this will sort the first expression value wise

Regards

Neetha