Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 |
.............
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 |
.............
Just Remove Sub-Total & Sub-Total Amount
Yes are your attention ok!!
Please solved my query.
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);
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);
Thank's