Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Add empty expression
I want empty row, but u r saying column.
Regards,
Kumar
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
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
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
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.