Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Hi Qlikview Experts,
I have one requirement.this requirement is possible or not tell me.
if is possible please guide me .
My Requirements,
In Excel i can delete label from excel table and make it first row as a Label. but how do to same functionaltity in qvd file
Please guide me.
Input table in QVD
General Info | |||||||
Port | Terminal | Cost Group | Cost ID | Cost Element | Valid From | Valid To | Currency |
Output table in frend end i want like this table
Port | Terminal | Cost Group | Cost ID | Cost Element | Valid From | Valid To | Currency |
Rergards
Perumal A
Did you try excluding the record on load and saving again?
Table_temp:
LOAD
*
FROM
$(vQVD_File)
(qvd)
WHERE ( recno() <>1 )
;
and then you store it in another QVD.
Reggards,
Santiago.
its not a good idea but i used to to do if there is a need
a:
load * Inline [
Date,amount
1/2/2012,100
];
LOAD Date as
[Order
Date],
amount as
[Order
amount]
Resident a;
its for only the field name with string
when its comes for no
valid frm and valid to and all
i used to go for valid & chr(10) & fromdate
valid & chr(10) & todate
=Chr(10)& vCYears &Chr(10)&'Budget ' & Upper(Month(Max({$<[YTD Flag]={1}>}Date)))
=Chr(10)& vCYears & chr(10)&'Actual ' & Upper(Month(Max({$<[YTD Flag]={1}>}Date)))
or else u can do like this
'cost' & chr(10) & 'group'
'Cost' & chr(10) & 'Element'
Hi Santigo,
First row is label of table . your condition will work when delete row records of table.i want delete label of qvd file.
if anybody know please guide me,
Regards
Perumal A