Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to add blank rows in a straight table

Hi All,

I have a requirement where I need to have blank rows inserted in a straight table.  I should use only a straight table but not a pivot table. Please suggest any ideas to achieve this.

3 Replies
vvvvvvizard
Partner - Specialist
Partner - Specialist

Concatenate nore rows of data to your fact table with inline load . Flag that data with a field. Set text of that data to match background color of your table using flag created earlier

Anonymous
Not applicable
Author

Thank you rawat.

But the thing is  that the blacnk rows should be coming in between. Say at the end of each primary dimension value.

If i add inline, what would be my approach to sort the table so that the blank rows comes in middle.

olivierrobin
Specialist III
Specialist III

hello

you should create a field used to sort your data

and manage to create adequate keys for your blank lines