Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Vigneshvaran
Partner - Contributor
Partner - Contributor

Blank Row in Straight Table

Hi,

I have a straight table and it has a column called "Sales ID". Is that possible to leave a blank row after distinct "Sales ID"?

17 Replies
sunny_talwar

Just add a calculated dimension with a space between two single quotes ' '

Vigneshvaran
Partner - Contributor
Partner - Contributor
Author

Hi Sunny,

Could you please explain me the syntax, since am new to Qlik.

sunny_talwar

Syntax is just this =' ' or without equal sign ' '

Vigneshvaran
Partner - Contributor
Partner - Contributor
Author

Hi,

Am sorry I couldn't get you. I need a below output in qliksense straight table, need a blank row after all distinct Sales ID.

1.PNG

sunny_talwar

My bad, I got myself confused with the columns and rows. I thought you wanted a blank column. My bad.... is this in QlikView or Qlik Sense? and do you know how many blank rows will you need in total or is this dynamic?

Vigneshvaran
Partner - Contributor
Partner - Contributor
Author

Hi Sunny,

This is in QlikSesnse, We don't have exact numbers, it should be dynamic!

sunny_talwar

I will check and get back to you

Vigneshvaran
Partner - Contributor
Partner - Contributor
Author

Thank you so much!

sunny_talwar

So, I was able to insert a blank row for each SalesOrderID, but I am unable to sort it in a way that it alternate... currently it just shows up at all SalesOrderID together and all empty rows together... this can be fixed if we can add SalesOrderID another time (may be at the end of the table), but this SalesOrderID will show the same number on both rows.... Is that something which can work for you?