load a list of expressions in an Excel file

[#1]

Hi all,

I want to load a list of expressions (about 100) in an Excel file. Then load this file into QlikView and interpret the expressions in a crosstab.

If it helps, I managed to make a skeleton that only works when you select a single expression.

Excel file:

ExpId	Expression
0	sum(Expression1)
1	sum(Expression2)
2	sum(Expression2)

Expression in the crosstab :

$(=Expression)

Thank you in advance,

Yacine

[consenit]

Hi there.

See the QVW and XLSX files attached.

Kind regards,

Ernesto.

[#3]

Thank you Ernesto but I need to show the entire table (all expressions) without any selection.

I want to show the list of expressions as it is in Excel.

example:

KPIs	Value
KPI1	100 (which is Expression1)
KPI2	200 (which is Expression2)

[Gysbert_Wassenaar]

If you load the expressions from excel they're just text values. You can't expand those to get a different expression for each row. If you want that kind of thing you'll have to create a variable that contains a pick-match expression. See this discussion: Expressions in Fields

[Peter_Cammaert]

Probably one of the very few things in QlikView that cannot be done like it really should. A dimension value cannot determine the actual expression used in the expression column simply by associative deduction. This would indeed be a godsend for constructing large dynamic metrics tables that get their expressions from an external source.

You can do it however using the hard way (complex IF THEN ELSE) or the less annoying way by using the Pick() function. See these:

http://community.qlik.com/message/370846#370846

http://community.qlik.com/message/541344#541344

http://community.qlik.com/message/247054#247054

also of use maybe:

http://community.qlik.com/message/466391#466391

Best,

Peter

[rwunderlich]

You can put each expression reference  in a separate column of a straight table and check "horizontal" on the Presentation pane to get the effect. For example:

$(=only({<ExpId={0}>}Expression))

Increment the ExpId for each column.

-Rob