Using expressions form Excel sheet

[rahulhv1]

Hi All,

I have created an excel sheet in which I have written all the parameters that I want in Col. A and in Col. B , I have written expressions which gives the value of each parameter , my question is, in qlikview , can I use Col. B as an expression. Example given as under.

Inupt

Required Output :

[swuehl · Accepted solution]

You can only use one expression per expression column, not changing the expression per dimension.

But you can have one expression that checks the dimension value and picks the appropriate calculation.

=pick(match( DimName, 'Sales','OPE'), Sum(Something1), Sum(Something2) )

You can build an expression like this from your table like described e.g. here:

Expressions in Fields