Drill down dimension with conditional logic

[paul_scotchford]

Hi,

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

Paul

[kaushiknsolanki]

Hi Paul,

Just a question, have you also used the if statement for other drill fields?

If not then it may not work.

Regards,

Kaushik Solanki

[paul_scotchford]

Hi Kaushik,

Why would it not work ?

Thanks

Paul

[kaushiknsolanki]

Because your other Fields may not be linked that the Financial Year or vice versa.

Regards,

Kaushik Solanki

[paul_scotchford]

I've solved the issue, it was an error in the calendar bridge table.

Creating the calculated dimensions mixed with other dimensions is perfectly fine, I should have checked the model load first.

[kaushiknsolanki]

Perfect

Regards,

Kaushik Solanki