topic Re: Using expressions form Excel sheet in QlikView

Using expressions form Excel sheet

rahulhv1 — Thu, 06 Aug 2015 14:49:14 GMT

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 :

Re: Using expressions form Excel sheet

swuehl — Thu, 06 Aug 2015 22:41:00 GMT

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