topic Re: Pivot table in Visualization and Usability

Pivot table

Mon, 17 Jul 2017 07:36:20 GMT

Hi, the only doubt I have is if we can change the column order after consolidating the table, or if we should start another table from scratch.

Thank you!!!

Joaquin.

Re: Pivot table

devarasu07 — Mon, 17 Jul 2017 07:56:28 GMT

Hi Joaquin,

Not required to re-create again. you can simple re-order column position (Measures & Dimension side).

Thanks Deva

Re: Pivot table

Mon, 17 Jul 2017 07:59:57 GMT

Hi Devarasu, and thank you for respodning. Would you mind to send screenshots? As I've already tried that way.

Thank you again!!

Joaquin.

Re: Pivot table

devarasu07 — Mon, 17 Jul 2017 08:38:31 GMT

Edit pivot table --> Data Tab there is an option allow Drag and Drop..for re-arrange the column positions at( row/columns/measure level). if your not looking this option can you share your app. then it's easy to check and assist you. tks

Re: Pivot table

Mon, 17 Jul 2017 09:08:29 GMT

Hi, is just what i tried at the beginning, and the rows in data table changes, but then the ones in the sheet doesn´t... so im really confused haha.

Thank you!!

Re: Pivot table

Anonymous — Mon, 17 Jul 2017 09:17:15 GMT

Those Rows may not change as fast as we expected. Will take some time to reflect on the sheets.

Re: Pivot table

Mon, 17 Jul 2017 09:54:49 GMT

sadasiva‌ although I wait they don't change, so what can i do?

Re: Pivot table

devarasu07 — Mon, 17 Jul 2017 10:04:15 GMT

Hi,

What version are you using it? Jun 2017 or older version. better can you share your mock app and also share your expected column order output. TKs

Re: Pivot table

Mon, 17 Jul 2017 10:17:28 GMT

Hi,

Im using June2017 version which is 11.11.1.

This is my order output, and I will like rappel, financ, and gestoria to go between II and III.

Re: Pivot table

devarasu07 — Mon, 17 Jul 2017 11:14:24 GMT

Hi,

Can you share you app (.qvf) file. tks

u can find u r app under below location (desk top client path)

C:\Users\[user Name]\Documents\Qlik\Sense\Apps