Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Not applicable
Author

No.

I created 3 variables in script like:

If (....) AS var1

If (....) AS var2

If (....) AS var3

And when I show the variables in the table, it looks like the picture attached in the above message, the text is spread over rows and columns. And the final view should be like in the picture, T1 with all text1 to text3 in one row.

whiteline
Master II
Master II

I show the variables in the table

Sorry, to help you I must understand how do you 'show it in the table'.

upd:

Oh, could you paste a load statement where you've created these 'variables'?

Not applicable
Author

I know it a little bit complicated to describe. I try to get a screenshot of the QlikView to show you. Since my working day is over now, I will upload it here as soon as possible.

Thanks for your help so far.

-Nick