topic Re: Need Help Qlikview in QlikView

Need Help Qlikview

Mon, 03 Nov 2014 05:03:42 GMT

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.

Re: Need Help Qlikview

anbu1984 — Mon, 03 Nov 2014 05:37:48 GMT

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

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

Re: Need Help Qlikview

Mon, 03 Nov 2014 05:44:56 GMT

Just Remove Sub-Total & Sub-Total Amount

Re: Need Help Qlikview

Mon, 03 Nov 2014 05:46:08 GMT

Yes are your attention ok!!

Please solved my query.

Re: Need Help Qlikview

anbu1984 — Mon, 03 Nov 2014 05:58:24 GMT

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);

Re: Need Help Qlikview

anbu1984 — Mon, 03 Nov 2014 06:01:26 GMT

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);

Re: Need Help Qlikview

Mon, 03 Nov 2014 06:05:20 GMT

Thank's