topic conditional rows in table in QlikView

conditional rows in table

Fri, 25 Mar 2011 10:12:03 GMT

Hi,

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.

Any help?

Thx!

deepakk — Fri, 25 Mar 2011 10:29:54 GMT

hi,

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)).

Anonymous — Fri, 25 Mar 2011 12:44:50 GMT

In situations like this I often create a calcualted dimension. Use your condition in the dimension calculation.