topic Re: Tabular chart Dimension and Measures column sorting in QlikView

Tabular chart Dimension and Measures column sorting

bhavikumehta — Fri, 16 Feb 2018 11:23:40 GMT

Hello,

my dashboard is having a tabular chart with few mandatory dimensions (12) and measures (5); and few conditional dimensions (18) and measures (6).

column order to be displayed in tabular chart is:

mandatory dimensions

conditional dimensions

mandatory measures

conditional measures

when i select 6 conditional dimensions, 5th and further conditional dimensions appears after mandatory measures.

kindly suggest how to maintain column order as mentioned above. thank you.

Re: Tabular chart Dimension and Measures column sorting

rubenmarin — Fri, 16 Feb 2018 11:51:31 GMT

Hi Bhavik, I think that the only option is to show all columns and manually relocate them dragging the column.

Re: Tabular chart Dimension and Measures column sorting

bhavikumehta — Fri, 23 Feb 2018 10:40:31 GMT

Hello Ruben - unable to drag columns. please suggest.

Re: Tabular chart Dimension and Measures column sorting

rubenmarin — Mon, 26 Feb 2018 10:37:29 GMT

Why unable to drag? can you upload a sample/screenshot to better understand the requirements?

Re: Tabular chart Dimension and Measures column sorting

bhavikumehta — Tue, 27 Feb 2018 13:08:52 GMT

PFA screenshot - it has Dimensions, then Expressions and then again Dimensions

Expected - All Dimensions should come first and then All Expressions.

FYI - Tabular chart shown in screenshot has 17 dimensions and 9 Expressions in selected layout

When i drag 'PHL3' to the left of 'Qty' expression, it shows arrows pretending that it is dragging while mouse key is pressed, once i release mouse key, dimension sits back at its original place. Please suggest.

Re: Tabular chart Dimension and Measures column sorting

rubenmarin — Tue, 27 Feb 2018 16:24:22 GMT

When I drag blue arrow shows and columns are moved, dimensions can be mixed with expressions, no matter if they are calculated or not.

In presentation tab there is an option to allow dragging columns, but if arrow shows it should be allowed.

I also tried to set only readable, sheet security... in all cases I can drag columns if it's allowed in presentation tab.

Can you reduce and/or scramble data to check in a sample?