I have a requirement for the user to select a calendar type from a list e.g. Fiscal or Standard, as such the drill down dimension will use a if statement coded this way for the calendar value to display ...
=if(CalendarType='Financial',[Fin Year Label], [Cal Year])
Then I have 3 more dimensions in the drill down.
The problem is when a user selects a single year on a chart the drill down does not go beyond the Year and the remaining dimensions are ignored.
If I replace the IF with e.g. [Fin Year Label] then the drill down will work but now we are stuck with a Fin Calendar .
Is this a limitation in QlikSense (June 2018 desktop) ? Or a bug ?
Thanks in advance