Discussion board where members can get started with QlikView.
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 A2 text2
cell A3 text3
Is that possible?
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.
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.
Maybe I'm missing something... Did you try to do what I mentioned above?
Could you explain your issue?
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.
Sorry, you show excel table.
How and where do you have three separate rows ? (in script or in chart)
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).
which have the arrangement
The arrangement where ?
When I let show me the 3 new variables in a table object.
You created a chart, set straight table, and created three expressions ?