Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
OrbytaQliker
Contributor II
Contributor II

Change how the records are showed in table

Hi everyone,

I have a table with the following records, in which each record belongs to its column, and in other columns will be empty.

first.png

[01,02,03,04

7090,$(null),$(null),$(null)

X090,$(null),$(null),$(null)

$(null),5090,$(null),$(null)

$(null),X090,$(null),$(null)

$(null),$(null),0090,$(null)

$(null),$(null),X090,$(null)

$(null),$(null),$(null),X090

]

But I'd like to show the data in the following way. Each column should have its records shown from the first row of the table, instead of having a lot of empty space.

after.png

[01,02,03,04

7090,5090,0090,X090

X090,X090,X090,$(null)

]

Thank you very much if you could dedicate some precious time to helping me.

Labels (1)
1 Reply
PrashantSangle

share the complete snip. What dimension you used on left side.

Share some data & required output. 

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂