topic Re: Delete label in QlikView

Delete label

perumal_41 — Thu, 25 Jul 2013 14:19:04 GMT

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

Re: Delete label

Thu, 25 Jul 2013 16:45:57 GMT

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.

Re: Delete label

nizamsha — Thu, 25 Jul 2013 16:59:54 GMT

its not a good idea but i used to to do if there is a need

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'

Re: Delete label

perumal_41 — Fri, 26 Jul 2013 10:54:52 GMT

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