Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Nicolas.
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.
Thanks,
Sangram.