topic pivot table join...??? in QlikView

pivot table join...???

Thu, 15 Jul 2010 03:25:35 GMT

Sorry. i do not speak english..

tab1:
LOAD * INLINE [
a, b
11, 1
22, 2
33, 3
];

tab2:
LOAD * INLINE [
c, d
11, 99
22, 88
];

I want not join. I want to handle the pivot table.

So...

I written....

sum({<a={"$(=GetFieldSelections(c))"}>}d)

current result:

i want results:

plz......

Anonymous — Thu, 15 Jul 2010 04:16:11 GMT

Here's an easy way to write the expression:

sum(if(a=c,d))

Thu, 15 Jul 2010 08:13:33 GMT

Thank you very much.

but...

'if' is performance problem.(over 10000000 data)

ex>

SUM({<STD_DT={'20100501'}>} IF((a = b) AND (c = d) AND (e = f) AND (g = h) AND (i = j),kk)

It is take a long time....(10 minute.) ^^;;;;