reg-sorting

[#1]

Hi Team

I have to sort the product in the straight table ;

i have products like synergy,ethics,oncolog,promot,ptc

in my previous UAT i have in correct format but in the prod the order is misplaced and it was ethics

                                                                                                                                     synergy

                                                                                                                                     oncology

                                                                                                                                     promot

                                                                                                                                     ptc

i have done  Ascending and given order ,and text also in Ascending.

but also iam getting wrong

i want to display my products in my production file like  synergis

                                                                                 ethics

                                                                                 oncology

                                                                                 promot

                                                                                 ptc

can any please help

[#2]

ethical

diabetes

oncology

promoted by product

chc

like this i should get in BU Coloumn

[avinashelite]

OK try like this in the script:

sortordertable:

Load * inline

[

BU,Value

synergis,1

ethics,2

oncology,3

promot,4

ptc,5

];

In the table where you have this BU feild add this code:

load *,

DUAL(BU,applymap('sortordertable',BU) as BU_with_Sort;

then use this field in the chart and in sort tab check the sort on Numeric ascending ;

this should work

[#4]

i shoud not do any modifications in script ,in the UAT and DEV the they have given as follows

sort---> expression--->ascending

                           --- order_bu

[avinashelite]

you cannot the share the app?? its hard to find the issue.

did you used the order_bu field in the expression??

[#6]

i have used BU in dimension

[stigchel]

The dual match should work as sort expression

=Dual(BU,match(BU,'SYNERGIS BU','ETHICS BU','ONCOLOGY BU','PROMOT BU','PTC BU'))

Where BU is the EXACT name of the field including capitals, Qlikview is case sensitive

and where the values EXACTLY match the e.g. SYNERGIS BU including capitalization in your field BU

Without sharing your qvw , I can't help you further. You could also make a sample qvw that demonstrates the problem, but where everything else is left out

See also attached

[avinashelite]

That's rite ,

do you have a field called order_bu??? if so they have asked you to use this field in the sort tab EXPRESSION and check Ascending .

select BU Dimension and in expression use that field.

[Anonymous]

hi,

you try  to order by text