4 Replies Latest reply: Dec 18, 2017 1:03 PM by Martin Pohl RSS

    Replicating Window/Table Calculations in Qlik

    carrie obrien

      Hello,

       

       

      In Tableau, I used a table calc to determine a person's failure rate, as shown below:

       

      WINDOW_COUNT(COUNT(if[Correct/Incorrect]="correct" then [Number of Records] end))/[Number of Records]

       

       

      is it possible to replicate this type of formula/logic in Qlik Sense? 

      I am evaluating products and this is a critical metric for our business. 

       

      Thank you,
      Carrie

        • Re: Replicating Window/Table Calculations in Qlik
          Luis Madriz

          Hi Carrie,

           

          In any of the aggregation functions in QS (Count, Sum, Max, etc.), you are able to define the scope of the aggregation with set analysis. Other powerful functions such as AGGR will help you define even more complex arrays of data.

           

          The combination of functions makes QS very powerful. There are also other functions specific to a table that helps you move in a "window" for example: Above(), Below(), etc. which combined with the aggregation Count, etc. will give you the results you want

           

          Just an example:

          Untitled.png

           

          I hope this helps

           

          Luis

          • Re: Replicating Window/Table Calculations in Qlik
            omar bensalem

            What exactly does this expression do in tableau? Maybe a little explanation so we could help? This could be achieved in different fashions; with the use of the classic if, else expressions or set expressions etc.. depends on the user's preference and the desired output.

             

            And please note: everything you can do with Tableau can be done (much faster) with Qlik and NOT viseversa

              • Re: Replicating Window/Table Calculations in Qlik
                carrie obrien

                Thank you for your responses omarbensalem and @luis

                 

                In Tableau, the expression allows me to look at the entire dataset and for each person on the team, evaluate their % Correct (or Incorrect).  The dataset is a compilation of tasks and each row has a person who did the task and whether they were correct or incorrect. I want to look at the data in its entirety to derive an overall %correct.  I hope I'm explaining that well enough!  

                 

                Sounds like I need to investigate the functions further!

              • Re: Replicating Window/Table Calculations in Qlik
                Martin Pohl

                for sure,

                in Qlik Sense you can use

                Count(if [incorrect/correct] = 'correct' ,1,0)/ Count([incorrect/correct])

                or, a faster solution

                Count({<[incorrect/correct]={'correct'}>} [incorrect/correct]) / Count ([incorrect/correct])

                regards