set analysis interpretation

[souadouert]

I load an excel file containing

indicator column

expression column (expresion set analysis)

then I look for the possiblity in a chart 'table' to add N dimension

and in the expresion I want to insert the column expression and qlik interpreted as an expression (Set Analysis)

[felipedl]

Hi Souad,

I've made a simple example as to what you need.

Put some expression on an excel file and loaded it on qlik to interpret.

See both files for reference.

Hope it helps,

COde is as follows:

data:

LOAD * Inline

[

SalesPerson,Location,Value

Bob,1,100

Ane,2,300

John,1,50

];

Exp:

LOAD Indicator,

     Expression

FROM

(ooxml, embedded labels, table is Plan1);

Felipe.

[souadouert]

hello Flip,

y dont undrstand me i have this script

LOAD * INLINE [

    CONQUETE, NOMBRE_CLIENT, REF

    OUI, 5, 1

    OUI, 4, 1

    NON, 2, 1

];

LOAD Indicateur, Expression

FROM (ooxml, embedded labels, table is Feuil1);

and  héave this table

i want use the olumn expression with expression  table

[YoussefBelloum · Accepted solution]

Hi,

you should read this:

Loading Expressions From File - WITHOUT creating variables in Script

[souadouert]

thank you youssef i will try this solution

[souadouert]

THANK YOU YOUSEEF

[YoussefBelloum]

you're welcome. good luck