This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a lot of data from our laboratory, and we have a field TAT (turn around time).
I need to make a table where only the rows of the table are shown where the TAT is bigger than 90% of all TAT's.
The condition is something like this: TAT > fractile(TAT,0.90)
But I don't know where or how to put it in my table.
In situations like this I often create a calcualted dimension. Use your condition in the dimension calculation.
View solution in original post
First you need to create pivot table. Add the required dimesnion and in Expression try the below code.
sum(if(TAT > fractile(TAT,0.9), TAT)).