Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
saumyashah90
Specialist
Specialist

List box of fields and not values of a field

I have

Header 1Header 2Header 3Header 4
1234
5678

I want a listbox  like

Header 1
Header2
Header3
Header4

and  also i want it selectable.

5 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Use Cross table and tranfor the data.  Check help file for syntax.

Hope this helps you.

Regards,

Jagan.

saumyashah90
Specialist
Specialist
Author

After many transformation i am creating this format so i dont think that would work

Not applicable

try to use CrossTable

syntax

table:

CrossTable(Header1, Value)

LOAD Header1,

    Header2,

    Header3,

     Header4

  

FROM  table;

jagan
Luminary Alumni
Luminary Alumni

Hi,

For this type of tables Cross Table is the apt one.  otherwise you can do like this

Data:

LOAD

     'Header1' AS HeaderNumber,

     Header1 AS HeaderValue

RESIDENT TableName;

LOAD

     'Header2' AS HeaderNumber,

     Header2 AS HeaderValue

RESIDENT TableName;

LOAD

     'Header3' AS HeaderNumber,

     Header3 AS HeaderValue

RESIDENT TableName;

LOAD

     'Header4' AS HeaderNumber,

     Header4 AS HeaderValue

RESIDENT TableName;

Hope this helps you.

Regards,

Jagan.

saumyashah90
Specialist
Specialist
Author

I am not taking this format as direct input.Otherwise i woulld have loaded it in Crosstable format

I am transforming manytables and geting almost 200 fields.