Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

conditional rows in table

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!

1 Solution

Accepted Solutions
mov
Champion III
Champion III

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

View solution in original post

2 Replies
deepakk
Partner
Partner

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

mov
Champion III
Champion III

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

View solution in original post