4 Replies Latest reply: Dec 14, 2016 11:54 PM by Swapnil Lopes RSS

    How to calculate Total of a grouped Drill Down Dimension?

    Swapnil Lopes

      I have created a drill down grouped dimension in QlikSense with around 10 dimensions in it.

      Now I am trying to calculate the Total Count of a dimension in relation to the grouped dimension.

      My expression is as follows:

      =count(total <grp_branch_appraiser_month> CREST_SERIAL_NO)


      Where <grp_branch_appraiser_month> is the grouped dimension.

      The expression is not giving any output as it fails to valuate the grouped dimension in the expression.

      Need a solution on this issue.

       

      Thank You.