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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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