Qlik Community

Qlik Sense App Development

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

New Contributor III

Drill-down and alternate states in Qlik Sense

Dear all,

Please find attached a screenshot shows a Balance Sheet.The dimensions of the Assets and Liabilities are identical drills except for the first dimension of the drill which filters already the Asset or Liabilities accounts. Question: how is it possible to drill in the Assets table without influencing the dimension of the Liabilities table ? In other words, how can the two tables be unlinked at dimension level ?

In QlikView we could not use the drill with alternate states because the states are not taken into account by the drills. The solution we found was to add the dimensions (not grouped) and use Conditions on dimensions. Since in Sense neither alternate states nor conditional dimensions exist, what could be a viable solution ?

Thank you in advance for your help.

Kindest regards,


1 Reply
Honored Contributor II

Re: Drill-down and alternate states in Qlik Sense

Hi Nicolus,

Alternates states is totally possible with sense aswell. Firstly check this out:

Qlik Sense - Comparative Analysis using Alternate States - YouTube

Also if this dosent help you can go with an extension to achieve it.