I have the following requirement,
The user should see the data according to selections. The Filter should be "Bi-Yearly" and the next filters should be "1st year" and "2nd Year" and the table should reflect data of the two years which have been filtered. Here as I use the year as same dimension in both 1st and 2nd year filters, it takes the same value. If I use alternate state, the data becomes zero. If I use create another dimension/column as year, Qlik still consider it as same dimension. If I create another column from different table it's not associating. Is there any possibility to do this.? Please find the below image for the requirement.
Thanks for your reply.
I don't want it as a current year and previous year. Both filters should have all the year values which is applicable in the table. The user should be able to select any years and the table should reflect the value.
There could be 2 options.
(a) Load 2 orphan Year data (Year 1) and (Year 2), that does not link to any of your dimension and fact tables. Your filter pane will be from the Year 1 and Year 2 table. Then in your chart, you can include in your formula where the Fact Year = to the Years selected for Year 1 and Year 2. You may consider using variables to identify value selected and use in your formula.
(b) Only have 1 Year filter pane. However, you can choose to only pick up Minimum Year and Maximum Year selected by users. With this option, you rely on users to rightfully only choose 2 years.