topic Straight Table : Filter in QlikView

Straight Table : Filter

Mon, 12 Mar 2012 14:47:28 GMT

I loaded a table from the database. I am displaying that table using straight table. It has about 100 Rows. However, I need to display only the row, for which one of the field matches a specific value. I tried calculation condition CENTER='5A9000P' but that does not work. It still displays all records. How can filter the row with CENTER='5A9000P' ?

Straight Table : Filter

jvitantonio — Mon, 12 Mar 2012 14:56:43 GMT

If you want to do it automatically, you need to use a chart instead of a table and in the dimension put

"=If(Center = '5A9000P', Center)

If you want to do it witha button, create a button, go to Actions, -->Add -->Select in Field. Put the field name and the value.

Straight Table : Filter

Mon, 12 Mar 2012 15:02:11 GMT

Thank you .. it worked. I chose Cross Tab and put the formula you wrote. Also chose the option to supress null values.