6 Replies Latest reply: Mar 5, 2018 5:04 PM by Krishna Nagulapally RSS

    Work-around for drillable dimension behavior

    Casey Marincin

      I am working in Qlik Sense 3.2.  I have a very simple app.  It has 1 internal table.  The fields are:

      ReportMonthYear

      TransactionAmount

      Employee

      Manager

      Director

       

      As you might guess, the Employee-Manager-Director relationship is a hierarchy, with the usual properties (i.e., 1 Director to many Managers, 1 Manager to many Employees).

       

      I have 2 visualizations:

      1)

      line chart of Total TransactionAmount vs ReportMonthYear

      2)

      bar chart of Total TransactionAmount vs drillable dimension Director \ Manager \ Employee

       

      My requirement is to make these 2 visualizations behave independently.  That is, selections in either visualization should not affect the other.  So, in my measure definitions, I have entered the following:

      Sum({1} TransactionAmount)

       

      However, I am noticing a particular situation in the data that violates this "visualization independence" requirement.  For a certain ReportMonthYear value, all rows in the table have the same Employee value (and, therefore, the same Manager and Director values as well).  That is, for the rows with this particular ReportMonthYear value, all rows have Employee = 'x', Manager = 'y', and Director = 'z'.  For this selection, Qlik automatically drills the dimension in the bar chart to the Employee level, which seems to contradict the purpose of the {1} set expression in its measure, and, of course, violates the "visualization independence" requirement.

       

      Is there a way to make Qlik not automatically drill for this particular data scenario?  My proposed work-around is to split the internal table up into 2 copies, 1 for each visualization.  But, I prefer a different solution, as this could become very difficult to maintain if I have to create more visualizations.