Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Selecting a value inside an excel cell

hey

i'm kind of new to qlikview, so any help would be much appreciated.

the problem i have is that in the excel sheet i have, the data i need is written with some other values.

for example, in the date field the data is written as " date= 02/03/14 " where as i just need the  02/03/14 part...

is there any way to extract it?

thankyou in advance

cheers

Tags (3)
1 Solution

Accepted Solutions
nilesh_gangurde
Valued Contributor

Re: Selecting a value inside an excel cell

Hi,

this can be done, please have a look on below mentioned script.

load Datefield,

        Right(Datefield, 😎 as NewDate,

From TABALE_NAME;

hope this will help you.

-Nilesh

9 Replies
mato32188
Contributor III

Re: Selecting a value inside an excel cell

U can use

date#(right([Your Date Field], 8), 'DD/MM/YY') as Date

nilesh_gangurde
Valued Contributor

Re: Selecting a value inside an excel cell

Hi,

this can be done, please have a look on below mentioned script.

load Datefield,

        Right(Datefield, 😎 as NewDate,

From TABALE_NAME;

hope this will help you.

-Nilesh

Not applicable

Re: Selecting a value inside an excel cell

subfield(Datefield,"=",2)

ravic906
Contributor III

Re: Selecting a value inside an excel cell

Hi,

Use this.

= date(right(date,10),'DD/MM/YY')

Not applicable

Re: Selecting a value inside an excel cell

use this in your load

Date(Date#(subfield(Datefield,"= ",2),'DD/MM/YYYY'),'DD/MM/YYYY') as CorrectDate  //If space is there after =

Otherwise

Date(Date#(subfield(Datefield,"=",2),'DD/MM/YYYY'),'DD/MM/YYYY') as CorrectDate

Not applicable

Re: Selecting a value inside an excel cell

thankyou very much.. ill try them all

Not applicable

Re: Selecting a value inside an excel cell

thankyou very much.. ill try them all

Not applicable

Re: Selecting a value inside an excel cell

thankyou very much.. ill try them all 

Not applicable

Re: Selecting a value inside an excel cell

thanks...