Re: merge shifted cells to one row - Qlik Community

Report Inappropriate Content · ‎2012-09-26

Hi,

I created 3 new variables via script but the expressions are shifted over row and column like that (example as it would be in Excel) :

cell A1 text1

cell B2 text2

cell C3 text3

but I would like to get it like that:

cell A1 text1

cell A2 text2

cell A3 text3

Is that possible?

-Nick

whiteline · ‎2012-09-26

Hi.

You could create a pivot without dimensions, add your expressions and then 'move' header row to the left with a mouse, so that you get a vertical alignment.

Report Inappropriate Content · ‎2012-09-26

Since my data are really big, I would need to do that some thousand times, so it isn't the solution for me to use the mouse.

whiteline · ‎2012-09-26

Maybe I'm missing something... Did you try to do what I mentioned above?

Could you explain your issue?

Report Inappropriate Content · ‎2012-09-26

Ok. Here is a picture. What I want to have is the T1 index with all text1 to text3 in 3 seperate comlumns but in the same row, and not all text information seperated over rows and columns.

Hope that helps.

whiteline · ‎2012-09-26

Sorry, you show excel table.

How and where do you have three separate rows ? (in script or in chart)

Report Inappropriate Content · ‎2012-09-26

I am creating 3 new variables via QlikView script and the result is 3 new variables in QlikView which have the arrangement as shown in Excel (only as an example).

whiteline · ‎2012-09-26

which have the arrangement

The arrangement where ?

Report Inappropriate Content · ‎2012-09-26

When I let show me the 3 new variables in a table object.

whiteline · ‎2012-09-26

Ok.

You created a chart, set straight table, and created three expressions ?