topic Sequence in QlikView

Sequence

Thu, 07 Jan 2016 07:42:15 GMT

Hi Experts,

I have Status field which consists of A,B,C,D. But i have a scenario where i have to show Status has in sequence like C,B,A,D. How to achieve this?

Thanks in Advance!!

Re: Sequence

oknotsen — Thu, 07 Jan 2016 07:55:27 GMT

Create an inline table at the start of your script for only that field in which you put the values in the order you want to have them. You can drop this helper table again at the end of your script. Next, sort the List Box on Load Order.

Re: Sequence

sasikanth — Thu, 07 Jan 2016 08:01:10 GMT

An inline table can help

Load * from Your table ;

concatenate

Load * Inline [

Status

[

status,No

C,1

B,2

A,3

D,4

]

Re: Sequence

jagan — Wed, 13 Jan 2016 02:57:21 GMT

Hi,

Try like this

LOAD

Dual(FieldName, Match(FieldName, 'C','B','A','D') AS FieldName_New

FROM DataSource;

Now in chart -> Sort -> Select Numeric

Regards,

jagan.