topic Re: evaluate row content in QlikView

evaluate row content

mambi — Sun, 31 Jan 2016 22:09:37 GMT

Hello,

i'm connecting qv with mysql db and i have a varchar field like this :

Column:

10+22

3-4

15+10

...

in the load script or in a chart i want to evaluate each row so i'll get :

Column

-1

i don't want to use subfield in the load script because it duplicate rows.

the function evaluation returns 0.

any idea how to do it ?

Re: evaluate row content

Anonymous — Sun, 31 Jan 2016 22:26:52 GMT

Use the Evaluate() function :

Load

Evaluate(Column) as Evaluated ,

;

LOAD * INLINE [

Column

10+22

3-4

15+10

];

Re: evaluate row content

mambi — Sun, 31 Jan 2016 22:30:42 GMT

i already tried this but when data come from mysql db the result is different (it's return 0)

Re: evaluate row content

Anonymous — Sun, 31 Jan 2016 22:38:59 GMT

Maybe force it to Text before the Evaluate :

Load

evaluate ((Text(Column)) as Evaluated ,

;

LOAD * INLINE [

Column

10+22

3-4

15+10

];

Re: evaluate row content

mambi — Sun, 31 Jan 2016 22:42:47 GMT

nothing

Re: evaluate row content

Anonymous — Sun, 31 Jan 2016 22:46:52 GMT

Works with a basic Inline Load, something must different with your actual data. Could you share a small qvd with some sample data ?

Re: evaluate row content

mambi — Sun, 31 Jan 2016 22:54:03 GMT

here's a qvd file

Re: evaluate row content

Anonymous — Sun, 31 Jan 2016 23:01:01 GMT

With that qvd it works fine like this :

LOAD

column ,

Evaluate(column)

FROM

test.qvd

(qvd);

qvw file attached.

Re: evaluate row content

mambi — Sun, 31 Jan 2016 23:07:21 GMT

it's will drive me crazy !!

your file works fine , but if i copy your script into my own file it's won't work :-(((

Re: evaluate row content

Anonymous — Sun, 31 Jan 2016 23:15:55 GMT

What if in your script you :

Load data from your mysql db
Store into qvd
Drop table
Load from the qvd & Evaluate()

Re: evaluate row content

mambi — Sun, 31 Jan 2016 23:18:52 GMT

tried this but no result,

now even if i reload your document i'm getting 0

Re: evaluate row content

mambi — Sun, 31 Jan 2016 23:21:01 GMT

which version of qv are you using please ?

Re: evaluate row content

Anonymous — Sun, 31 Jan 2016 23:22:02 GMT

QV11.20 SR8

Re: evaluate row content

mambi — Sun, 31 Jan 2016 23:24:29 GMT

i'm using QV11.20 SR2

can we get the same result with a chart ( without using evaluate function) ?

Re: evaluate row content

MarcoWedel — Tue, 02 Feb 2016 23:42:40 GMT

Hi,

one front end solution could be:

=Pick(Match(column,'$(=Concat(column,chr(39)&','&chr(39)))'),$(=Concat(column,',')))

hope this helps

regards

Marco

Re: evaluate row content

mambi — Wed, 03 Feb 2016 09:03:22 GMT

thank you for your help Sir,

but what if i have a large set of data -> performance ?

is there any solution to do it via the loading script ?

Re: evaluate row content

perumal_41 — Thu, 04 Feb 2016 05:55:29 GMT

Hi ,

Evaluate() function will work. but still problem with Evaluate(), then use below script

Load *,

if (mid(column,FindOneOf(column, '+-*/')) ='+',

Left(column,FindOneOf(column, '+-*/') -1)+Right(column,len(column)-FindOneOf(column, '+-*/') ),

if (mid(column,FindOneOf(column, '+-*/')) ='-',

Left(column,FindOneOf(column, '+-*/') -1)-Right(column,len(column)-FindOneOf(column, '+-*/') ),

if (mid(column,FindOneOf(column, '+-*/')) ='*',

Left(column,FindOneOf(column, '+-*/') -1)*Right(column,len(column)-FindOneOf(column, '+-*/') ),

Left(column,FindOneOf(column, '+-*/') -1)/Right(column,len(column)-FindOneOf(column, '+-*/') ) ))) as New_column

Resident table;

Re: evaluate row content

mambi — Thu, 04 Feb 2016 12:27:25 GMT

Thanks a lot for your help,

it also works but what if i have 10+23+14+.... (NB : in the same row i have only one sign + or - )