Blank Row in Straight Table

[Vigneshvaran]

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"?

[sunny_talwar]

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

[Vigneshvaran]

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]

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.

[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]

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]

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?