Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
paul_scotchford
Valued Contributor

Drill down dimension with conditional logic

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

5 Replies

Re: Drill down dimension with conditional logic

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
Valued Contributor

Re: Drill down dimension with conditional logic

Hi Kaushik,

Why would it not work ?

Thanks

Paul

Re: Drill down dimension with conditional logic

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

Regards,

Kaushik Solanki

paul_scotchford
Valued Contributor

Re: Drill down dimension with conditional logic

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.

Re: Drill down dimension with conditional logic

Perfect

Regards,

Kaushik Solanki