Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

carrieobrien
New Contributor

Replicating Window/Table Calculations in Qlik

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

4 Replies
luismadriz
Valued Contributor

Re: Replicating Window/Table Calculations in Qlik

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

OmarBenSalem
Esteemed Contributor

Re: Replicating Window/Table Calculations in Qlik

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

carrieobrien
New Contributor

Re: Replicating Window/Table Calculations in Qlik

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!

martinpohl
Valued Contributor II

Re: Replicating Window/Table Calculations in Qlik

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

Community Browser