topic Re: Filter the records in QlikView

Filter the records

Mon, 18 Aug 2014 05:56:39 GMT

Hi All ,

I Have two tables with CustomerId in one table and fiscalmonth ,fiscal year in another table, now i want to filter the records which are in current fiscalmonth and current fiscal year ,the expression should be in load script.

Please help me.

Thanks.

Re: Filter the records

MK_QSL — Mon, 18 Aug 2014 05:59:07 GMT

Load * From Your Tablename where [Fiscal Year] = Year(Today()) and [Fiscal Month] = Month(Today())

Re: Filter the records

tresB — Mon, 18 Aug 2014 06:07:52 GMT

If cutomerid is there in both the tables, you can join the tables on that key and then apply the filter like:

JoinedTab:

Load

CustomerID, Otherfields From <table1>;

Left/Right Join

Load

CustomerID, FiscalYear, FiscalMonth from <>table2;

NoConcatenate

Final:

Load

* Resident JoinedTab Where FiscalYear=Year(Today()) and FiscalMonth= Month(Today());

Drop Table JoinedTab;

Re: Filter the records

Mon, 18 Aug 2014 06:17:48 GMT

Thanks Manish & tresesco

my fiscal year is like the below , as per my requirement i need cid2 record only now like wise next month the ids which are in sept i need those records.

custid	fiscalmonth	fiscalyear
cid1	jun	2015
cid2	aug	2015
cid3	july	2015
cid4	sep	2014
cid5	oct	2014
cid6	jan	2014
cid7	feb	2014
cid8	mar	2014
cid9	apr	2015
cid10	may	2015
cid11	jan	2013
cid12	feb	2013

Re: Filter the records

Mon, 18 Aug 2014 06:23:43 GMT

can u upload the document?

Re: Filter the records

Anonymous — Mon, 18 Aug 2014 06:38:20 GMT

Hi John,

Load * from table2 where FiscalYear=Year(Today()) and FiscalMonth= Month(Today())

inner join

load custid from table1.

example with sample values:

FISC:

Load * Inline

[custid,fiscalmonth,fiscalyear

cid1,jun,2015

cid2,aug,2014

cid3,july,2015

] Where fiscalyear =year(today()) and MonthName(today());

inner join

load * inline

[custid

cid1

cid2

cid3];

Regards,

Chinna