Need Help Qlikview

[#1]

Dear All,

I want to help in qlikview.

I have a column Type of Expense & Others Column of Amount.

I allow type of Expense head wise Amount but Null values allow the Sub Total Amount.

So my quarry how i remove sub Total & Sub Total Amount. 

Please See my attachment.

[anbu1984 · Accepted solution]

Is this your expected output?

Type of Expense	Amount
QC	550.00
H/O Staff	55.00
Govt & Non Govt Official	5,656.00
Tiffin	64.00
Lunch	154.00
Factory Official	163.00
Iftar	45.00
Factory Incharge	15.00
Night/Dinner
Buyer	558.00
QC	62,045.00
Staff	656.00
Factory Worker
Govt. & Non Govt. Official
Factory Incharge	6,456.00

.............

[#3]

Just Remove Sub-Total & Sub-Total Amount

[#4]

Yes are your attention ok!!

Please solved my query.

[anbu1984]

LOAD [Sl. No.],

     [Type of Expense],

     [Purpose in Details],

     [Name of Employee],

     Designation,

     [Department/ Section],

     [No of Day/s],

     Particulars,

     F9,

     F10,

     Amount,

     Remarks

FROM

[20171025AAL.xlsx]

(ooxml, embedded labels, header is 2 lines, table is FactoryExpenses)

WHERE( Len(Trim([Type of Expense])) > 0);

[anbu1984]

Load *,If(IsNum([Sl. No.]),[Sl. No.],Peek([Sl. No._New])) As [Sl. No._New];

LOAD [Sl. No.],

     [Type of Expense],

     [Purpose in Details],

     [Name of Employee],

     Designation,

     [Department/ Section],

     [No of Day/s],

     Particulars,

     F9,

     F10,

     Amount,

     Remarks

FROM

(ooxml, embedded labels, header is 2 lines, table is FactoryExpenses)

WHERE( Len(Trim([Type of Expense])) > 0);

[#7]

Thank's