position

[smilingjohn]

Hi Al

I have a filter which has 6 fields in it , to sort it i need to write  an order expression , for which i see the fields under the filter according to the required oreder.

But when i set " Always Select One Value" and try to select the filed it keeps moving to the first place . I want it to be fixed .

Is ther any way to do it ? I need to have the  expression checked becuase that is required for the order.

Iam attaching a QVW from sample data . please look into this .

[MK_QSL]

check !

[smilingjohn]

Hi Manish

Bu i need this order to be displayed

if(material='iron',1,if(material='pastry',2,if(material='protien',3,if(material='vitamin',4,5)))

And for which i need to set this under sort  expression , and the defualt order is coming from database ,

How do i handle this requirement ?

I hope its clear for you now

[sasikanth]

hi,

try this expression in expression tab

=WildMatch(Only({1}material),'iron','pastry','protien','vitamin')

[smilingjohn]

No

I have attached the file

please find the attachment

[sasikanth · Accepted solution]

pls. check the attachment

[MK_QSL]

Like this?