Clicking on a column assigned to another column

Fri, 04 Dec 2009 01:54:47 GMT

I have a table as below

Supplier ID Status
--------+----+---------+
ABC 100 Complete
ABC 200 Complete
ABC 300 Pending
DEF 400 Complete
DEF 500 Pending
DEF 600 Pending

By default, when I click on Complete on the first row, the result set will be

Supplier ID Status
--------+----+---------+
ABC 100 Complete
ABC 200 Complete
DEF 400 Complete

I would like to have the option to drill only on a specific row. For instance, when clicking on Complete on the first row, I would like to only see the record where ID = 100 and not all the records where Status=Complete.

Is there a way of accomplishing this without clicking on the ID itself ?

Thanks.

Clicking on a column assigned to another column

Fri, 04 Dec 2009 03:27:19 GMT

For this behavior I would suggest a unique status field per ID, it is easily created with a dual. See attached app.

Tom

Clicking on a column assigned to another column

Fri, 04 Dec 2009 04:06:02 GMT

Thanks Tom ! This is exactly what I'm looking for.

topic Clicking on a column assigned to another column in QlikView

Clicking on a column assigned to another column

Clicking on a column assigned to another column

Clicking on a column assigned to another column