Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Joining a Standalone inline table with Main table

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

Labels (1)
4 Replies
Highlighted
Specialist II
Specialist II

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

Highlighted
Contributor II
Contributor II

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?

Specialist II
Specialist II

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

Highlighted
Contributor II
Contributor II

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.