Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mambi
Creator III
Creator 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 ?

1 Solution

Accepted Solutions
MarcoWedel

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

View solution in original post

17 Replies
Anonymous
Not applicable

Use the Evaluate() function :

Load

Evaluate(Column) as Evaluated ,

*

;

LOAD * INLINE [

    Column

    10+22

    3-4

    15+10

];

mambi
Creator III
Creator III
Author

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

Anonymous
Not applicable

Maybe force it to Text before the Evaluate :

Load

evaluate ((Text(Column)) as Evaluated ,

*

;

LOAD * INLINE [

    Column

    10+22

    3-4

    15+10

];

mambi
Creator III
Creator III
Author

nothing

Anonymous
Not applicable

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

mambi
Creator III
Creator III
Author

here's a qvd file

Anonymous
Not applicable

With that qvd it works fine like this :

LOAD

  column ,

  Evaluate(column)

FROM

test.qvd

(qvd);

qvw file attached.

mambi
Creator III
Creator III
Author

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 :-(((

Anonymous
Not applicable

What if in your script you :

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