Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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
and héave this table
i want use the olumn expression with expression table
thank you youssef i will try this solution
THANK YOU YOUSEEF
you're welcome. good luck