How to make selection of value in the field, if that value is not associated with the selected year.
I have a list box for Order No, Fiscal Year, Month and I have a straight table which shows data for selected filters along with its cumulative sum.
Challenge I am facing is-
When I select Order no. say, 1001, which is associated only to fiscal year 2010, where the cumulative sum against it is 0, now when I select Fiscal year 2018 with month Aug, I should still get the sum as 0 as Order falls only for 2010, but as the Order number is associated with only to FYear 2010, the moment I change the Filter of Fiscal year from 2010 to 2018, the order number selection gets cleared, which is true as per Qlik functionality, but I still want same order number to be selected, even though its not associated to other years.
I tried using, Only({<FYear=, FMonth=>}[Order No]), but I am getting empty result.
Any solution for this?
