topic Re: table with different row formulas in column in QlikView

table with different row formulas in column

Wed, 08 Aug 2012 05:54:32 GMT

need to show an excel like table where I have some items in rows that require different formulas.

Like:

I have experimented with conditional expressions in a straight table like

Dimension = Label

Expression 1: =sum(a) with condition Order=1

Expression 2: =sum(b) with condition Order=2

and using pick

Expression 1: =pick(Order, sum(a), sum(b)

but both methods did not work.

Juerg

Sat, 11 Aug 2012 16:06:05 GMT

Hi,

Try the below expression's:

Exp 1:

IF(Order=1, sum(a), IF( Order = 2,sum(b)))

Exp 2:

IF(Order=1, sum(a),sum(b))

Regards,

Desmortes

Mon, 13 Aug 2012 05:45:48 GMT

The evaluation of Order seems not to happen on the row level. therefore the formula works only if a single Order value is selected?