topic Re: position in QlikView

position

smilingjohn — Thu, 11 Feb 2016 06:40:34 GMT

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 .

Re: position

sasikanth — Thu, 11 Feb 2016 06:45:24 GMT

HI,

Try to uncheck the State check box in SORT tab

Or try this in expression tab

wildmatch(only({1} Field,'value1',Value2')

Re: position

MK_QSL — Thu, 11 Feb 2016 06:46:04 GMT

Go to sort tab of list box

Untick State (Auto Ascending/Ascending/Descending)

Re: position

smilingjohn — Thu, 11 Feb 2016 06:48:24 GMT

Nothing is checked except expression ,

becuase i need the fields to be shown in that perticular order , And it should not be moved to first place when i slecet them . It should remain constant at the same place

Re: position

Chanty4u — Thu, 11 Feb 2016 06:49:28 GMT

can u share sample screen shot ? or qvw with that lisbox?

Re: position

MK_QSL — Thu, 11 Feb 2016 06:49:39 GMT

Provide sample app or screenshot of your List box sort tab

Re: position

sasikanth — Thu, 11 Feb 2016 06:51:08 GMT

can you share your expression?

your list box have vertical scroll bar? in that case it will jump to 1st place by default

Re: position

Chanty4u — Thu, 11 Feb 2016 06:53:07 GMT

un chk in sort tab state and text

Re: position

smilingjohn — Thu, 11 Feb 2016 07:01:34 GMT

Hi Manish Plz look at the attachment

I dont want the fields to move it should remain the constant

Re: position

smilingjohn — Thu, 11 Feb 2016 07:02:38 GMT

Under sort there is only expression being checked becuase that is needed for ht esorting .

I have shared an example qvw also

Re: position

MK_QSL — Thu, 11 Feb 2016 07:07:46 GMT

check !

Re: position

smilingjohn — Thu, 11 Feb 2016 07:12:07 GMT

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

Re: position

sasikanth — Thu, 11 Feb 2016 07:12:08 GMT

hi,

try this expression in expression tab

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

Re: position

smilingjohn — Thu, 11 Feb 2016 07:13:11 GMT

I have attached the file

please find the attachment

Re: position

sasikanth — Thu, 11 Feb 2016 07:17:06 GMT

pls. check the attachment

Re: position

MK_QSL — Thu, 11 Feb 2016 07:17:28 GMT

Like this?