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.

souadouert
Valued Contributor

set analysis interpretation

I load an excel file containing

indicator column

expression column (expresion set analysis)

exemple.PNG

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)

1 Solution

Accepted Solutions
YoussefBelloum
Esteemed Contributor

Re: set analysis interpretation

6 Replies
felipedl
Valued Contributor III

Re: set analysis interpretation

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
Valued Contributor

Re: set analysis interpretation

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
Capture.PNG

i want use the olumn expression with expression  table

YoussefBelloum
Esteemed Contributor

Re: set analysis interpretation

souadouert
Valued Contributor

Re: set analysis interpretation

thank you youssef i will try this solution

souadouert
Valued Contributor

Re: set analysis interpretation

THANK YOU YOUSEEF

YoussefBelloum
Esteemed Contributor

Re: set analysis interpretation

you're welcome. good luck