Regarding Pivot Sorting

[d_koti24]

Hi All,

I Have pivot table like this:

sample_table:

ENV                DIR                                                SIZES(gb):

RAP                RAP_USER                                       200

                       RAP_TUSER                                     300

DEV               ....                                                      ....

UAT                ....                                                       ....

PROD             PROD ENV                                       150

LIKE this.

my req is i want to sort  like this

in env fied:

DEV

UAT

RAP

PROD

How to achive this?

Regards,

kd

[Colin-Albert]

If you define the data as a DUAL value, then the sort will be applied automatically.

CustomENV:

LOAD

     Dual( Line, Order) as Line

inline [
Line, Order
DEV,1

UAT,2

RAP,3

PROD,4
];

[veidlburkhard]

Hi koti,

in order to sort ENV go to the 'Sort' Tab and sort ENV by Expression

=Match(ENV, 'DEV', 'UAT', 'RAP', 'PROD')

That's all.

Regards

Burkhard

[d_koti24]

=match(Environment, 'DEV','UAT', 'RAP_ARCH','PROD')

I was tried,but i did nt get.

[veidlburkhard]

Why don't you send us a screenshot of the sort tab so we can check and correct...?

[d_koti24]

Hi All,

Find the sample app.

i want to sort the 1st dimension ,

like dev,uat,rap,prod. in front end only.

regards,

kd !

[veidlburkhard]

Now it is clear, koti.

In the script you have to create a field envr like this:

Then you can use this field as your dimension in the pivot chart instead of your calculated dimension.

The sorting is done very easily now with the match funktion:

Regards

Burkhard

[robert_mika · Accepted solution]

=if(match(Dir,' \\abghg\DEV','\\deh\DEV1','\\fgfgd\DATA','\\dgfgfgf\GM0100','sampleDEV01'),dual('DEV',1),

if(match(Dir,'\\MW1010\12000','\\jhjhjhjK\GMW','\\SDV064\GMTQT0101'),dual('RAP_ARCH',3),

if(match(Dir,'\\NA0063\GMTQT0099','DASHBOARDS','GBI','DASHBOARDSC'),Dual('PROD',4),

if(match(Dir,'DASHBOARDSUAT','GBIUAT'),Dual('UAT',2),dual('',5)))))

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[d_koti24]

With out createing envr in script level,is there any chance to do in sort exp.

regards,

kd

[robert_mika]

See my post below

[d_koti24]

Thanks alot Robert.

regards.