3 Replies Latest reply: Sep 16, 2015 2:31 PM by Brad Holtzman RSS

    Pivot table: Measure as percentage of total Row

      Hello!

       

      I'm fairly new to Qlik Sense, am still figuring stuff out. Have looked on the forums and this seems to be a recurrent problem, yet I don't see an answer to my specific question.

       

      I have the pivot table (see below) constructed for 2 columns (in or out of policy) across 2 years (2014 and 2015). I have also written the expression so that the data pulls from a specific category (called 'Air').

       

      Currently the count (or number of Air transactions) in or out of policy is expressed as a percentage of the total Air transactions across both years. What I want to do is to change the denominator in my expression so that it pulls as a percentage of the specific year it occurs in (as a percentage of the row total).

       

      qlik1.JPG

       

      Please see below for my expression script, have tried distinct years, have tried specifying [Year] = {2014,2015}. But all to no avail.

       

      (count({1<[TYPE] ={Air},distinct[Year]>}SPEND))

      /

      (count(Total{1<distinct[Year],[TYPE] ={Air}>}SPEND))

       

      Any help would be much appreciated!


      Many thanks


      Leo