How to use Filters from another InLine file

Anonymous — Wed, 05 Nov 2014 14:48:26 GMT

Hi All

Is there any way to use filters from InLine parameter file like table below?

I have one fact file and fetching Amount for below output. If few lines than I can simply write condition for each lines. But I have more than 200 lines in report. Output is exactly like below. I need to match PSheetID and PLnNo to the fact table and getting last column Balance(not listed in below)

Reading as

If PLnNo='UCX1', sum({<SHEET_ID=pSheetID, LINE_NUMBER ={'6','20'} Sales)-sum({<SHEET_ID=pSheetID, LINE_NUMBER ={'13','23'}>} Sales)

If PLnNo='UCX2', sum({<SHEET_ID=pSheetID, LINE_NUMBER ={'13','23'}>} Sales)

ELSE sum({<SHEET_ID=pSheetID, LINE_NUMBER =pLnNo Sales)

This is not complete syntax but idea.

Point is how to use FILTERS from InLine file please

Thanks

PSheetID	Req	PLnNo	Section	Head	LnNm
A.1.b	N	1	ASSETS	Securities	Held to Maturity (HTM)
A.1.b	N	2	ASSETS	Securities	Available for Sale (AFS)
A.1.b	6+20-13-23	UCX1	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Real Estate Loans (ex CRE Loans)
A.1.b	13+23	UCX2	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	CRE Loans
A.1.A	N	30	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	C&I Loans
A.1.b	N	35	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Credit Cards
A.9.b	N	38	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Other Consumer
A.1.b	N	43	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Other Loans and Leases
A.9.z	N	109	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Unearned Income on Loans
A.1.b	N	110	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Allowance for Loan and Lease Losses
A.1.b	N	111	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Total Loans and Leases
A.1.b	52+66-59-69	UCX3	ASSETS	Loans Held for Investments at Amortized Cost	Real Estate Loans (ex CRE Loans)
A.1.b	59+69	UCX4	ASSETS	Loans Held for Investments at Amortized Cost	CRE Loans
A.1.b	N	76	ASSETS	Loans Held for Investments at Amortized Cost	C&I Loans
A.1.3	N	80	ASSETS	Loans Held for Investments at Amortized Cost	Credit Cards
A.1.5	N	81	ASSETS	Loans Held for Investments at Amortized Cost	Other Consumer
A.1.5	N	86	ASSETS	Loans Held for Investments at Amortized Cost	Other Loans and Leases
A.1.0	N	110	ASSETS	Loans Held for Investments at Amortized Cost	Unearned Income on Loans
A.1.b	N	111	ASSETS	Loans Held for Investments at Amortized Cost	Allowance for Loan and Lease Losses

topic How to use Filters from another InLine file in QlikView

How to use Filters from another InLine file