Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rank_nandha
Contributor II

Pivot Navigation

Hi All,

I have a pivot table in the name of Company name, Employees and some other as dimension, also i have salary, expense, etc., as the measures. Can i change the position of the dimesions or measures without changing it in properties. I.e., can i click and move the particular column from one to another place?

Need this info immediaetly as i want to deliver a report by today.

Rgds,

Nandha

7 Replies
jonbrough
Valued Contributor

Re: Pivot Navigation

You can, and this is default behaviour. Make sure you have 'Allow pivoting' checked on the presentation tab.

Jonathan

rank_nandha
Contributor II

Re: Pivot Navigation

John,

Thnaks for the quick response.

I know we can move the vertical column to row column and row column to vertical column. My requimnt is i have a vertical column by say column1, column2, column3, column4. I want to click and drop the column1 in between column3 and 4. Is this possible?

Rgds,

Nandha

jonbrough
Valued Contributor

Re: Pivot Navigation

You can do that too, though note that if you have conditional shows on your expressions you sometimes have to unset the conditon, add the new dimension, and then reset the condition, else the new dimension appears to the right of the expressions and can't be shifted to the left of them.

Jonathan

rank_nandha
Contributor II

Re: Pivot Navigation

Jonathan,

I have attaced a sample with this, can you help me how to do this in step by step process and change the table?

Rgds,

Nandha

jonbrough
Valued Contributor

Re: Pivot Navigation

See attached file in which I:

1. expanded the 4 dimension columns

2. drag and dropped column 1 to between 3 and 4

3. re-expanded the columns after the drag'n'drop

If step 3 is a problem, tick the 'Always fully expanded' checkbox on the presentation propeties. I notice that the blue drag'n'drop line indocators are not so clear in that mode though.

I'm using Qv11 SR1, and done this in both the developer software an on the Ajax client.

Jonathan

rank_nandha
Contributor II

Re: Pivot Navigation

Your are right Jonathan. Is this possible for measure columns?

Rgds,

Nandha

jonbrough
Valued Contributor

Re: Pivot Navigation

That's trickier, as Straight tables allow sorting but not grouping, and Pivot tables allow sorting but not grouping.

Try adding a Expression Sort that has the same expression that you want to sort on.

If however the users need to change this sorting order you could set each expression formula up within a variable, and have another variable that the user change to switch between those expression formula variables. You could then set the switching variable as the sort condition. This would be a fair amount of effort for not so much gain I think though.

Jonathan

Community Browser