1 Reply Latest reply: Sep 6, 2016 12:36 PM by Jason Michaelides RSS

    Set Measure to a specific Field.

    Salamon Musayev

      Hello,

       

      I have chart that measures compliance rate per month.

      The following are my dimension and measures.

       

      Dimension:  Month

      Dimension:  Compliant

       

      Measure (expression):  Count( {<Compliant = {'Yes'} >} Month )/Count(Total <Month> Compliant)

       

      This gives me a beautiful chart that measure compliance rate by month, and if I click a specific department it will present the compliance rate for that location as well.

       

      However I would like to also create another monthly chart but only set to a specific location (for example location 'B2A').

       

      ( I have been able to create a gauge meter set to a specific location based on help from a Qlik community members by using the following:

       

      Count({<Compliant={'Yes'},Location={'B2A'}>} Compliant) /Count({<Location={'B2A'}>} Compliant)

       

      I would like to reproduce the same logic as for gauge meter but see the compliance change between months.

       

      Please help or advice.

       

      Thank you