Filter row values in table

Anonymous — Mon, 12 Dec 2016 20:41:13 GMT

Hi All

Ive got a table in the following format:

ID	STATUS	Pending	Done
1	Pending	1
1	Done	1	1
2	Done		1
3	Pending	1
3	Done	1	1
4	Peding	1

It means: In the beggining of the day, the pending activities are shown in the table and we will only have one row per ID (Status = Pending - like row number 1). If the activity is done, then another row of the same ID is created (like row number 2).

It is possible to do an activity that wasnt on the list in the begging of the day, so it will be shown in the table like row number 3 (ID = 2).

What I want is: A list of every activity that is pending in the begging of the day and was not done yet.

Thx in advance!

topic Filter row values in table in QlikView

Filter row values in table