Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
perumal_41
Partner - Specialist II
Partner - Specialist II

Delete label

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
PortTerminalCost GroupCost IDCost ElementValid FromValid ToCurrency

Output table in frend end i want like this table

PortTerminalCost GroupCost IDCost ElementValid FromValid ToCurrency

Rergards

Perumal A

3 Replies
Not applicable

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.

nizamsha
Specialist II
Specialist II

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'

perumal_41
Partner - Specialist II
Partner - Specialist II
Author

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