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: 
Anonymous
Not applicable

need a blank row in straigjt table

Hi,

I have created a straight table and it has one dimensional column and 9 expressions are there. But at end of the table i need a blank row needs to be inserted. Is there any way to achieve this blank row.

Regards,

Kumar

6 Replies
robert_mika
Master III
Master III

Add empty expression

23-Apr-15 8-41-55 AM.jpg

Anonymous
Not applicable
Author

I want empty row, but u r saying column.

Regards,

Kumar

Anonymous
Not applicable
Author

Hi

Try loading a blank row from inline load and concatenate the table with original table so your table have a ' ' value then in straight table show all values also uncheck suppress missing values.

Thanks

BKC

Anonymous
Not applicable
Author

Hi Robert,

I have a dimension called Day and deriving the expressions using set analysis. The data is as below. Need to achieve the last row which is =(C8/AVERAGE(C5:C7))-1 where C5=39,233; c6=30924; C7=27609 and C8=39443.

Regards,

Kumar

Anonymous
Not applicable
Author

Hi Chandel,

I have a dimension called Day and deriving the expressions using set analysis. The data is as below. Need to achieve the last row which is =(C8/AVERAGE(C5:C7))-1 where C5=39,233; c6=30924; C7=27609 and C8=39443.

Regards,

Kumar

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

Where is the source data?

I have an idea.

Please copy and paste into qvw file and reload

Table:

LOAD * INLINE [
Name,  Value
AAA, 00010
BBB, 00020
CCC, 3020567
DDD, 34567
EEE, 5678
'', ''
]
;

Have Name  as your dimension and value as your expression, this will give you your extra blank row.

Also, when you load your qvd file (assume qvd is used) just concatenate exact same field names but the value will be quote (' '). To achieve optimization I will have this stored in qvd file and just concatenate it to any table in where I want to the extra field as blank.

Give it a try and let us know the outcome.