topic Re: set analysis interpretation in QlikView

set analysis interpretation

souadouert — Wed, 13 Dec 2017 18:38:28 GMT

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)

Re: set analysis interpretation

felipedl — Wed, 13 Dec 2017 19:28:18 GMT

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.

Re: set analysis interpretation

souadouert — Wed, 13 Dec 2017 20:00:04 GMT

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

Re: set analysis interpretation

YoussefBelloum — Wed, 13 Dec 2017 20:22:42 GMT

Hi,

you should read this:

Loading Expressions From File - WITHOUT creating variables in Script

Re: set analysis interpretation

souadouert — Wed, 13 Dec 2017 20:47:42 GMT

thank you youssef i will try this solution

Re: set analysis interpretation

souadouert — Thu, 14 Dec 2017 07:59:23 GMT

THANK YOU YOUSEEF

Re: set analysis interpretation

YoussefBelloum — Thu, 14 Dec 2017 08:33:14 GMT

you're welcome. good luck