topic Divide a Field values into 2 list boxes. in QlikView

Divide a Field values into 2 list boxes.

narender123 — Mon, 15 Apr 2013 10:58:14 GMT

I have a column "Regime" and i want it divide into 2 list boxes.This fied having multiple value like C1,C2,C4S,c,E1,E2,E3,T1,T2,T3,T,Z,... etc.

1st list box show the values start with C means C* after that name the list box as Import and 2nd list box show the values start with E means E* after that name the list box as Export.

Thanks in advance.

Re: Divide a Field values into 2 list boxes.

fdelacal — Mon, 15 Apr 2013 12:04:02 GMT

i THING YOU NEED SOMETHING THAT THE QVW, I ATACH.

Hope that help you.

Re: Divide a Field values into 2 list boxes.

jagan — Mon, 15 Apr 2013 12:26:58 GMT

Hi Narender,

In load script arrive two new fields for Import and Export

Data:

LOAD,

Field,

If(Field Like 'C*', Field) AS Import,

If(Field Like 'E*', Field) AS Export

FROM DataSource;

Now you can use Import and Export filters. Hope this helps you.

Regards,

Jagan.

Re: Divide a Field values into 2 list boxes.

narender123 — Mon, 15 Apr 2013 13:22:41 GMT

Thanks.It is working.

Re: Divide a Field values into 2 list boxes.

narender123 — Mon, 15 Apr 2013 13:31:40 GMT

Thanks Jagan.

Its also working.