Multiple Cross Table

Wed, 10 Mar 2010 19:01:44 GMT

Hi!

I need something like doing a cross table twice.

I have an excel table that looks like this:

Qualifier1, Qualifier2, DataA_Period1, DataA_Period2, DataA_Period3, DataB_Period1, DataB_Period2, DataB_Period3

and I need it like this:

Qualifier1, Qualifier2, Type, Period, Data
... , ... , A, Period1, <data>
... , ... , A, Period2, <data>
... , ... , A, Period3, <data>
... , ... , B, Period1, <data>
... , ... , B, Period2, <data>
... , ... , B, Period3, <data>
.....

any ideas?

thanks in advance.

topic Multiple Cross Table in QlikView

Multiple Cross Table