topic Re: How to add blank rows in a straight table in QlikView

How to add blank rows in a straight table

Anonymous — Wed, 18 Apr 2018 17:20:59 GMT

Hi All,

I have a requirement where I need to have blank rows inserted in a straight table. I should use only a straight table but not a pivot table. Please suggest any ideas to achieve this.

Re: How to add blank rows in a straight table

vvvvvvizard — Wed, 18 Apr 2018 17:28:46 GMT

Concatenate nore rows of data to your fact table with inline load . Flag that data with a field. Set text of that data to match background color of your table using flag created earlier

Re: How to add blank rows in a straight table

Anonymous — Thu, 19 Apr 2018 06:16:32 GMT

Thank you rawat.

But the thing is that the blacnk rows should be coming in between. Say at the end of each primary dimension value.

If i add inline, what would be my approach to sort the table so that the blank rows comes in middle.

Re: How to add blank rows in a straight table

olivierrobin — Thu, 19 Apr 2018 07:12:06 GMT

hello

you should create a field used to sort your data

and manage to create adequate keys for your blank lines