topic Re: Transpose Field values in QlikView

Transpose Field values

qv11user — Sat, 16 Nov 2024 00:40:07 GMT

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

Re: Transpose Field values

sunny_talwar — Fri, 15 May 2020 13:50:56 GMT

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

Re: Transpose Field values

qv11user — Fri, 15 May 2020 14:09:32 GMT

Hi Sunny,

Thanks for your response.

I need to implement this in Straight table.

Regards,

QV user

Re: Transpose Field values

sunny_talwar — Fri, 15 May 2020 14:19:01 GMT

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.