Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
laddu_927
Specialist
Specialist

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
Specialist
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

laddu_927
Specialist
Specialist
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