topic Specific selection for different tables in QlikView

Specific selection for different tables

Wed, 29 Feb 2012 14:19:37 GMT

Hi there,

I have four pivot tables like this and would like to change the first column independently between these four tables:

I have four perspectives and in each table one of the perspective should be displayed. (detach is not workin)

Can anyone help me please?

Thanks a lot!

Specific selection for different tables

swuehl — Wed, 29 Feb 2012 14:26:47 GMT

Not really sure if I got your requirements properly, a more concrete example may help.

I think you can probably work with a calculated dimension or set analysis in your expressions, if the perspectives are somewhat fix, or use alternate states for your different charts.

Regards,

Stefan

Specific selection for different tables

Wed, 29 Feb 2012 14:29:07 GMT

HEy swuehl,

thanks for the fast reply.

Two question: what are alternate states?

Second: I tried set analysis in my expressions but it didn't work. I use if formulas may tht be the problem?

Thanks!

Specific selection for different tables

swuehl — Wed, 29 Feb 2012 14:34:06 GMT

Alternate states are available since QV11.

Up to QV11, a selection in e.g. a list box will affect all objects, the only way to override this was to use a per-object set analysis expression. Using alternate states, you can 'group' your sheets / objects in a way that a selection will only affect objects in the same group. Very nice for comparisons (perspectives?)..

To say anything about your issue with the set expression or if() function, you would need to give more details, at best using a small sample app or by stating the exact expressions.

Specific selection for different tables

Wed, 29 Feb 2012 14:45:13 GMT

Hi ,

unfortunately I still use QV10. But I solved the problem in a different way. Just collapsed all dimensions I didn't need. Not very pretty but it suits my purpose. Kind of obvious but I somehow didn't see it before.

Thanks anyway!!