topic Re: Drill down dimension with conditional logic in App Development

Drill down dimension with conditional logic

paul_scotchford — Thu, 19 Jul 2018 03:55:11 GMT

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

Re: Drill down dimension with conditional logic

kaushiknsolanki — Thu, 19 Jul 2018 05:49:23 GMT

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

Re: Drill down dimension with conditional logic

paul_scotchford — Thu, 19 Jul 2018 07:00:52 GMT

Hi Kaushik,

Why would it not work ?

Thanks

Paul

Re: Drill down dimension with conditional logic

kaushiknsolanki — Thu, 19 Jul 2018 07:05:38 GMT

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

Regards,

Kaushik Solanki

Re: Drill down dimension with conditional logic

paul_scotchford — Thu, 19 Jul 2018 23:47:11 GMT

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

kaushiknsolanki — Fri, 20 Jul 2018 08:31:31 GMT

Perfect

Regards,

Kaushik Solanki