topic Re: about the column order in a table in QlikView

about the column order in a table

Anonymous — Mon, 15 Sep 2014 09:09:05 GMT

Hi, all,

As recently, we saw a strange behavior of QV table and NPrinting. Though the problem was solved. But I still have a question about the order of the columns in QV.

The situation is like this:

We have 2 dimension columns D1 and D2, and order as D1 (first), D2 (second) in the "Dimension" tab, and 10 Expression columns (E1,E2, ,...,E10). And D1 is set as "Hide Column" in Presentation tab. So we see the table like this:

------------------------------

C1 | C2 |... |Cn | CEnd

------------------------------

D2 | E1 | ... |E9 | E10

As we have problem to match the data in nprinting, we thought C1 holds the data of D2, but it is not, C1 holds data of E1. And Cn holds data of D2, CEnd holds data of E10.

Then we try to check what is wrong. And found the weird thing : when we set D1 as "Show Column" back, then the table order become like this:

---------------------------------------

C1 | C2 |... |Cn | CEnd | Cn+1

---------------------------------------

D1 | E1 | ...| E9 | E10 | D2

As now the D2 is at the end of the table, it is really strange. It should be at C2. But, I do not know whether D2 is manually moved to the end of the table before D1 is set as "Hide Column".

Now, my question is: if D1 and D2 are the only tow dimensions in the table. D1 is set as the first column, and D2 is set as the last column. After set "D1" as "Hide Column", whether it is a normal behavior that D2 will be automatically moved to C1?

Re: about the column order in a table

Anonymous — Mon, 15 Sep 2014 11:52:07 GMT

BTW, this is a straight table.

Re: about the column order in a table

Andrea_Ghirardello — Thu, 16 Oct 2014 14:02:09 GMT

Hi Zhihong,

I suggest you contact the support team directly.

Here you can find lots of tutorials and you can give feedback or request support: Customer Feedback for Vizubi

In any case, this kind of issue usually happens when you move columns (dimensions or expressions) within the chart and then you hide one or some of them.

I suggest you show all columns, then restore the original order (dimensions first, then expressions), finally hide again the columns.

Save the chart and the document , re-map the object inside the NPrinting template (right click on the table object, click on update) and and try again.

Hope this helps.

Andrea

Re: about the column order in a table

Anonymous — Fri, 17 Oct 2014 09:24:49 GMT

Hi, Andrea,

Thanks for your suggestion.

Re: about the column order in a table

pgdavis2 — Thu, 27 Nov 2014 14:09:20 GMT

Thanks that solved my problem!

Re: about the column order in a table

Andrea_Ghirardello — Thu, 27 Nov 2014 14:28:36 GMT

Great.

Please mark the answer as helpful or correct so other users may find it easily.

Best,

Andrea

Re: about the column order in a table

pgdavis2 — Thu, 27 Nov 2014 14:39:32 GMT

I "Liked" it. Perhaps only the OP can mark is as Answered (?)

Re: about the column order in a table

Anonymous — Thu, 27 Nov 2014 14:44:24 GMT

Hi, guys,

Just mark it. Thanks