Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

14 Replies

Re: Blank Row in Straight Table

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

Vigneshvaran
New Contributor

Re: Blank Row in Straight Table

Hi Sunny,

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

Re: Blank Row in Straight Table

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

Vigneshvaran
New Contributor

Re: Blank Row in Straight Table

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

Re: Blank Row in Straight Table

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
New Contributor

Re: Blank Row in Straight Table

Hi Sunny,

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

Re: Blank Row in Straight Table

I will check and get back to you

Vigneshvaran
New Contributor

Re: Blank Row in Straight Table

Thank you so much!

Re: Blank Row in Straight Table

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?

Community Browser