topic Re: Can I make a switch button which can exchange the column and row in pivot table? in QlikView

Can I make a switch button which can exchange the column and row in pivot table?

Mon, 10 Dec 2012 10:19:33 GMT

Hello

Like the pic shows, Table 1 and table 2 are pivot tables and have the same content.

I want a button to switch table1 and table2. How can I do ? Does a micro do this?

I think there must be a property which can control the tables.

Who can help me about this? Thank you very much.

Re: Can I make a switch button which can exchange the column and row in pivot table?

m_woolf — Mon, 10 Dec 2012 11:09:40 GMT

You could make 2 pivottables and use a button to determine which is visible.

Re: Can I make a switch button which can exchange the column and row in pivot table?

Mon, 10 Dec 2012 11:11:57 GMT

you can do it by macro

see att file

Re: Can I make a switch button which can exchange the column and row in pivot table?

Tue, 11 Dec 2012 01:30:56 GMT

Hi mwooif，

Thanks for your reply.

Because of my dimensions and expressions are all dynamic. My opinion trended towards Pari Pari‘s even I don not understand his opinion totally.

Re: Can I make a switch button which can exchange the column and row in pivot table?

Tue, 11 Dec 2012 02:42:56 GMT

Hi Pari Pari,

From your test qvw 's macro I find the difference between sub1 and sub2 is the sequence

chart.AddDimension "week"
chart.AddDimension "year"

But I can't understand why the difference could affect the table’s stucture.

So could you please explain me more in details?

Thank you

Re: Can I make a switch button which can exchange the column and row in pivot table?

Tue, 11 Dec 2012 02:50:05 GMT

I get it!

The key is cp.TableProperties.NumberOfLeftDimensions = 0

Re: Can I make a switch button which can exchange the column and row in pivot table?

Tue, 11 Dec 2012 06:24:23 GMT

HI Pari,

One more question:

I wanna switch between 2 tables below. Let the macro control the table's look like.

I look up the API Guide but no clue. Please help me again. Thanks .

Re: Can I make a switch button which can exchange the column and row in pivot table?

Tue, 11 Dec 2012 07:56:34 GMT

i can't see the difference between your tables...

Re: Can I make a switch button which can exchange the column and row in pivot table?

Tue, 11 Dec 2012 08:22:44 GMT

The second column label. One is "sum(value)" the other is blank.

I can drag the label to switch with mouse.

But I want a macro to control that.

Re: Can I make a switch button which can exchange the column and row in pivot table?

Tue, 11 Dec 2012 08:59:43 GMT

it is a something like bug

why you want to achieve that?

i suggest to use (show/hide) label name for this expression in your macro script

see att qvw file

Re: Can I make a switch button which can exchange the column and row in pivot table?

Tue, 11 Dec 2012 09:17:23 GMT

My purpose is not show/hide the label but I want to allways display the left chart when the chart first show.

The right chart is unexpected. I don't know why and when will show the right chart.

And when I add an expression qv may be get a "bug" . In the attachment the label will appear until I click the button twice.

Re: Can I make a switch button which can exchange the column and row in pivot table?

Tue, 11 Dec 2012 09:25:14 GMT

what we are talking about is a little bit difrent than what you write in your first post

so could you write once again from the beggining what you want to achieve?

Re: Can I make a switch button which can exchange the column and row in pivot table?

Wed, 12 Dec 2012 00:35:15 GMT

Thank you for you patient on my bad question and poor English.

Question 1：

You have answered my question in my first post. And I know I can use "NumberOfLeftDimensions" to control the pivot table.

Question 2：

The second question comes from the first question. When I control my table with "NumberOfLeftDimensions", I find that the table will look like below pic sometimes.

But the BLANK label is unexcpected. I know I can let the label appear by dragging the BLANK label with mouse.

What I want to do is shows the correctly table when users open the qvw file firstly. I don't want users drag the BLANK label with mouse themselfs because of the "BUG".

Re: Can I make a switch button which can exchange the column and row in pivot table?

Wed, 12 Dec 2012 10:16:32 GMT

now i understand:)

could you paste macro here?

or whole qvw file

Re: Can I make a switch button which can exchange the column and row in pivot table?

Wed, 12 Dec 2012 12:24:10 GMT

http://community.qlik.com/servlet/JiveServlet/download/290108-51131/test%20pivot-4.qvw

Re: Can I make a switch button which can exchange the column and row in pivot table?

Wed, 12 Dec 2012 12:36:18 GMT

i cant see the bug

send (your) not mine file

Re: Can I make a switch button which can exchange the column and row in pivot table?

Wed, 12 Dec 2012 13:04:18 GMT

tomorow mornig i'll be out of base and be back on friday

so see you then

Re: Can I make a switch button which can exchange the column and row in pivot table?

Thu, 13 Dec 2012 00:51:14 GMT

Have a nice weekend ！

Here is my test qvw.