Qlik Community

App Development

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

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
paul_scotchford
Specialist
Specialist

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
paul_scotchford
Specialist
Specialist
Author

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
paul_scotchford
Specialist
Specialist
Author

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".