Discussion Board for collaboration related to QlikView App Development.
We have a business rule to use different data for year 2018, since there are no data for 2018 on primary source.
I prepared some use case QVW.
LOAD * INLINE [ID, Year, Amount1, Amount21, 2018, 1002, 2018, 2003, 2018, 3004, 2018, 4005, 2018, 5006, 2018, 6007, 2018, 7008, 2019, 5000, 8009, 2019, 6000, 900];
Primary source is Amount2, but for 2018 I want to use Amount1.
I dont want to do big changes in my expression. So the question is, ho to do it best? Probably with set analysis. (better without IFs).
What I want in straight table, is this:
Thank you for help.