Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

merge shifted cells to one row

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

12 Replies
whiteline
Honored Contributor II

Re: merge shifted cells to one row

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.

Not applicable

Re: merge shifted cells to one row

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
Honored Contributor II

Re: merge shifted cells to one row

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

Could you explain your issue?

Not applicable

Re: merge shifted cells to one row

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
Honored Contributor II

Re: merge shifted cells to one row

Sorry, you show excel table.

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

Not applicable

Re: merge shifted cells to one row

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
Honored Contributor II

Re: merge shifted cells to one row

which have the arrangement

The arrangement where ?

Not applicable

Re: merge shifted cells to one row

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

whiteline
Honored Contributor II

Re: merge shifted cells to one row

Ok.

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

Community Browser