4 Replies Latest reply: Jan 9, 2018 8:23 AM by TOBIAS LEIVA MORENO RSS

    How to use filter in an expression and then use Count

    TOBIAS LEIVA MORENO

      Hi everybody.

       

      I am a new to Qlik sense and I am hoping you can help with resolving issues I am having.

      I need your help with this:


      I have this table in Excel:

      table.JPG

       

      I need to create a KPI with this idea:

      Total Status (Finish)/Total Accept (Ok) for each year and after create another KPI with the variation of 2016 vs 2017

       

      My last idea was this:

      If( Year('2017'),Count({<[Status]={'Finish'}>}[Status])/Count({<[Accept]={'Ok'}>}[Accept]),)

       

      I try some diferents ways to do it but i can´t.

      could your help me?!!