Limiting records displayed in a straight table

[Anonymous]

I have the following straight table:

I want to restrict records displayed in the above table where the ActionFlag = 000 and the rest should not be displayed in the table.

How can this be accomplished in QV?

Regards

[sunny_talwar]

Is this a straight table or table box? for straight table you can use set analysis to make only ActionFlag = 000, but for table box the only solution would be to move this table in an alternate state and make a selection of ActionFlag = 000 and lock it down so that it cannot be cleared.

[Anonymous]

Thanks Sunny, it is a straight table. I tried to use a calculated dimension like:

ActionFlag = 000

and this does not work

[sunny_talwar · Accepted solution]

Use set analysis in your expressions:

{<ActionFlag = {000}>}

[jagan]

Hi,

Calculated Dimension will have performance issues when you have huge data, so better use set analysis to eliminate the unwanted records

Example:

Sum({<ActionFlag = {'000'}>} FieldName)

OR

Count({<ActionFlag = {'000'}>} FieldName)

This will have better performance than calculated dimension.

Regards,

Jagan.

[Anonymous]

Thanks Sunny, i had done it at the back end limiting data load with a where clause.

[Anonymous]

Thanks Jagan, however the table has no facts and only has dimensions for display and selections