Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kumarreddy257
Contributor

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

Re: need a blank row in straigjt table

Add empty expression

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

kumarreddy257
Contributor

Re: need a blank row in straigjt table

I want empty row, but u r saying column.

Regards,

Kumar

balkumarchandel
Valued Contributor II

Re: need a blank row in straigjt table

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

kumarreddy257
Contributor

Re: need a blank row in straigjt table

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

kumarreddy257
Contributor

Re: need a blank row in straigjt table

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
Valued Contributor II

Re: need a blank row in straigjt table

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.

Community Browser