topic USING STRING FUNCTION INCREASING OR DECREASING THE LENGTH OF STRING in QlikView

USING STRING FUNCTION INCREASING OR DECREASING THE LENGTH OF STRING

nizamsha — Wed, 03 Jul 2013 09:29:00 GMT

LOAD * INLINE [
Country
    IND
    AUS
    WI
    NZ
];

I need the output in the below format. Without using dual() Function and use extra field but dont display it in the output.

its sould be in the listbox like this

INDIA

AUSTRALIA

WESTINDIES

NEWZELAND

I USED MID FUNCTION IN MY LISTBOX SO ITS WORKING FINE.. BUT I WANT TO SEE THE COUNTRY IN LISTBOX WITH OUT WRITTING CONDITION IN LISTBOX

I HAVE ATTACHED A QVW FILE

Re: USING STRING FUNCTION INCREASING OR DECREASING THE LENGTH OF STRING

RedSky001 — Wed, 03 Jul 2013 09:49:44 GMT

If you don't want to use an expression in a list box why don't you move the expression into the script to make a new field? Not sure I understand your question at all in fact.

Re: USING STRING FUNCTION INCREASING OR DECREASING THE LENGTH OF STRING

nizamsha — Wed, 03 Jul 2013 09:54:35 GMT

HI MARK

I TRIED IN THAT TYPE .BUT I WANT IN ANOTHER TYPE

Re: USING STRING FUNCTION INCREASING OR DECREASING THE LENGTH OF STRING

RedSky001 — Wed, 03 Jul 2013 09:56:22 GMT

Another type of what? (I don't understand your question, my first response was a guess)

Re: USING STRING FUNCTION INCREASING OR DECREASING THE LENGTH OF STRING

nizamsha — Wed, 03 Jul 2013 10:04:34 GMT

MARK I THINK U WILL UNDERSTAND THIS ONE

THIS IS MY LOAD STATEMENT

LOAD * INLINE [
Country
    IND
    AUS
    WI
    NZ
];

I WANT THE OUTPUT LIKE THIS... IN LIST BOX

COUNTRY

INDIA

AUSTRALIA

WESTINDIES

NEWZELAND

HOW CAN I DO THIS..

Re: USING STRING FUNCTION INCREASING OR DECREASING THE LENGTH OF STRING

er_mohit — Wed, 03 Jul 2013 10:05:19 GMT

TRY THIS

ADC:

MAPPING LOAD * INLINE [

nO,Country

1, IND

2, AUS

3,WI

4,NZ

];

Map COUNTRY using ADC;

LOAD * Inline [

COUNTRY

INDIA

AUSTRALIA

WESTINDIES

NEWZELAND

];

Re: USING STRING FUNCTION INCREASING OR DECREASING THE LENGTH OF STRING

nizamsha — Wed, 03 Jul 2013 10:12:41 GMT

THANKS MOHIT

THATS WORKS PERFECT IS THERE ANY OTHER WAY

Re: USING STRING FUNCTION INCREASING OR DECREASING THE LENGTH OF STRING

er_mohit — Wed, 03 Jul 2013 10:14:46 GMT

Yeah using rowno() like this

ADC:

MAPPING LOAD RowNo() as Key, * INLINE [

Country

IND

AUS

];

Map COUNTRY using ADC;

LOAD * Inline [

COUNTRY

INDIA

AUSTRALIA

WESTINDIES

NEWZELAND

];