topic Re: Short in QlikView

Short

Fri, 13 Jul 2012 19:49:36 GMT

i have a selection box where i have used category column

and value of category is like

abc

dec

xyz

ghd

hji

jky

and i want to short it like

jkl

xyz

dec

hji

abc

jky

i have tried by using inline table as category

jkl ,01

xyz,02

dec,03

hji,04

abc,05

jky,06

as no assign as column s.no

and try to short expession s,no

assending

but not getting desired result ,

is there any way to short as i need.

Re: Short

CELAMBARASAN — Fri, 13 Jul 2012 19:51:43 GMT

Load the sort order in inline before the loading the main table

then use sort by as Load Order

Re: Short

MayilVahanan — Fri, 13 Jul 2012 19:57:05 GMT

Hi,

Use like this,

= wildmatch(FieldName,'jkl','xyz','dec','hji','abc','jky') in Sort tab ->expression and give ascending

(Or)

Load * inline

[

FieldName,Value