Joining a Standalone inline table with Main table

[ajith_qlik]

Hi Team,

Iam having a static hardcoded "year" inline table that mainly consists of random years between 2015 and 2025 that Iam mainly using as a filer to my main report. The inline table does not have any common joining to the "main details" table from which the columns are being pulled in the main report. Due to this when Iam filtering on suppose year 2020, Iam getting duplicate rows in main report. how can I avoid that.  This filter is also being used in as a calculated condition in the report .

example : Load * inline [year

2015

...

...

2025];

Please help me in this.

regards

Ajith

[JustinDallas]

If it doesn't join to the main table, then how is filtering supposed to work?

[ajith_qlik]

Iam finding means to join both the tables using some user created keys. Is there any way to do it? In short if I select 2020 in the static filter the report should get filtered for the specific year. What is the way to do it? or is there any other way apart from creating a standalone static filter to achieve this?

[JustinDallas]

Sounds like you are trying to create a Master Calendar

https://community.qlik.com/t5/New-to-QlikView/How-to-Create-Master-Calendar/td-p/103109

[ajith_qlik]

No its not. Let me rephrase my issue. I need a filter for year running from 2015 to 2025. Suppose I select 2020 from the list of values, the report would give me projections whether the shipment arrived in 2020 or will it arrive in 2021. So if it arrived in 2020, it will show status as Goods Delivered for that GoodsID and if not it will show as Goods  would be Delivered in next year. So in short there is no filterations happening (my bad as I mentioned it as filtering earlier), its just updating the statuses for the GoodsID based on this list of years. In short its giving a perspective for that year for that Goods ID. Let me know how I can achieve this.