Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
Vigneshvaran
Partner
Partner

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
sunny_talwar

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

Vigneshvaran
Partner
Partner

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
Partner

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
Partner

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
Partner

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?