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


      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:



      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?!!