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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
shumailh
Creator III
Creator III

Can we add blank rows in GRID?

I wanted to format my grid similar to some report in excel where i have blank rows in a grid. Is that possible that we can add blank rows at specific number in a grid?

Shumail

3 Replies
shumailh
Creator III
Creator III
Author

Can anyone help me out in this?

shumailh
Creator III
Creator III
Author

Still not get the solution on this, please help?

Miguel_Angel_Baeyens

Hello Shumail,

It's possible since you can read an entire excel file, including empty rows. What you need to do is creating a new field in the LOAD part of the excel file with

RecNo() AS RowNumber


and then start your charts with RowNumber as dimension.

Hope that helps