topic cross table in QlikView

cross table

Wed, 28 Jul 2010 14:04:20 GMT

Hello!

I want to create a cross table where the user chooses which dimensions are uses (e.g. from a list box or something like that).
So far I can only create a pivot table (cross-tab), which uses a predetermined number of dimensions.

Is this possible?

Thanks for your help.

Steffen

cross table

kji — Wed, 28 Jul 2010 14:20:04 GMT

I think you can use cyclic groups as dimensions, and possibly expressions groups as well to achieve something like this.

cross table

Wed, 28 Jul 2010 14:20:09 GMT

Yes it is possible by using If statements

AW:Re: cross table

Thu, 29 Jul 2010 09:23:32 GMT

Thanks for your quick help Johan. This is exactly what I meant.

Unfortunately, should the user can select from more than 50 dimensions.
That means for a two-dimension cross-table, that in both groups each 50 dimensions exist.
The user then has 2500 different varieties. This is no longer comfortable.

Can I make it that the end user adds the dimensions of the two cyclic groups dynamically, eg by selecting or drag and drop?

Greetings Steffen