Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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