topic Re: Straight tables: dynamic Horizontal/Vertical in QlikView

Straight tables: dynamic Horizontal/Vertical

Wed, 18 Dec 2013 10:33:05 GMT

Hi All,

I would permit to the user to rotate some tables (straight tables).

I mean the user may decide to see the figures

	Departments
Locations

	Locations
Departments

We I design the object there is a flag Properties / Presentations / Horizontal, but the user cannot change it.

How can I solve it?

May I create a button with a macro?

But, in this case, could you please send me an example of code?

Any other idea is welcome

Thanks a lot

Ciao

Clever_Anjos — Wed, 18 Dec 2013 10:54:46 GMT

An approach is having 2 objects, one rotated other normal.

Use a button setting a variable to 0 or 1.

Set each graph Layout/Show condition to varible = 0 or variable =1

Wed, 18 Dec 2013 16:23:18 GMT

Thanks Clever,

And using only one table? I would avoid to duplicate and so maintain 2 tables

bbi_mba_76 — Wed, 18 Dec 2013 16:31:25 GMT

Hi,

I think you could use calculated dimensions with the flag:

if the flag=1 then the first dimension will be the Locations, else the Departments

the opposite for the second dimension

Gysbert_Wassenaar — Wed, 18 Dec 2013 17:05:52 GMT

See attached example

Clever_Anjos — Wed, 18 Dec 2013 17:57:04 GMT

gwassenaargave the solution using only one pivot table .

If you can use a pivot table this solution fits.