Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
qv11user
Contributor
Contributor
‎2020-05-15 09:43 AM

Transpose Field values

Hi Team,

Hope all are doing good!

I have a column called Part Number which contains numbers like below

Part Number
-----------
P1,P2,P3,P4,P5,P6

But I need output of column as like below

Part Number
----------
P1
P2
P3
P4
P5
P6

I need to implement this in the Front-end (Not in the script level).

Can you please help me to achieve this?

Stay Safe!

Regards,

QV User

Labels (1)
Labels
508 Views
0 Likes
3 Replies
sunny_talwar
MVP
MVP
‎2020-05-15 09:50 AM

Which object do you want to view this in? Text box object? straight table?

505 Views
0 Likes
qv11user
Contributor
Contributor
‎2020-05-15 10:09 AM
Author

In response to sunny_talwar

Hi Sunny,

Thanks for your response.

I need to implement this in Straight table.

Regards,

QV user

502 Views
0 Likes
sunny_talwar
MVP
MVP
‎2020-05-15 10:19 AM

In response to qv11user

So, basically you want to use it as a dimension? Are there other dimensions? I would suggest to convert it into script, otherwise you will be complicating your chart way to much.

499 Views
0 Likes