topic different expressions in table column in QlikView

different expressions in table column

Thu, 09 Aug 2012 14:40:13 GMT

my problem seems of low interest, maybe I use the wrong titles

Any way to create a table showing values like

KPI	Value
EBIT	= sum(EBIT_Detail)
EBIT %	= sum(EBIT_Detail) / sum(yield_Detail)

It's required that the % is in the same column (as I will have more rows with individual expressions)

I have an excel like grid in mind where I can set the cells content / formula

Juerg

Re: different expressions in table column

Anonymous — Thu, 09 Aug 2012 15:06:52 GMT

load a dummy table like

load* inline[

KPI

EBIT
EBIT%

]

and use a straight table with dimension as KPI and use expression if( KPI=EBIT,sum(EBIT_detail),if(KPI= EBIT%,sum(EBIT_Detail) / sum(yield_Detail)))

Re: different expressions in table column

Mon, 13 Aug 2012 05:43:14 GMT

That is more or less what I tried but it does not work because - as I assume - the evaluation of the formula condition does not happen on the row level?

I think now about aligning text boxes into a gridlike layout - will cost me the selection feature however.

Correction:

Sorry - I was wrong.

What I tried was using a sequence number and =pick(sequence, <expr1>,<expr2>...)

and

multiple expressions with the conditions sequence=1, sequence=2

which did not work.

It does however work with the multiple if's.

Juerg