Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mambi
Contributor III

evaluate row content

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

32

-1

25

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 ?

Tags (2)
1 Solution

Accepted Solutions

Re: evaluate row content

Hi,

one front end solution could be:

QlikCommunity_Thread_203656_Pic1.JPG

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

hope this helps

regards

Marco

17 Replies

Re: evaluate row content

Use the Evaluate() function :

Load

Evaluate(Column) as Evaluated ,

*

;

LOAD * INLINE [

    Column

    10+22

    3-4

    15+10

];

mambi
Contributor III

Re: evaluate row content

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

Re: evaluate row content

Maybe force it to Text before the Evaluate :

Load

evaluate ((Text(Column)) as Evaluated ,

*

;

LOAD * INLINE [

    Column

    10+22

    3-4

    15+10

];

mambi
Contributor III

Re: evaluate row content

nothing

Re: evaluate row content

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

mambi
Contributor III

Re: evaluate row content

here's a qvd file

Re: evaluate row content

With that qvd it works fine like this :

LOAD

  column ,

  Evaluate(column)

FROM

test.qvd

(qvd);

qvw file attached.

mambi
Contributor III

Re: evaluate row content

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

What if in your script you :

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