Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
chitemerere
Valued Contributor

Limiting records displayed in a straight table

I have the following straight table:

Screen Shot 2015-12-09 at 02.15.08.png

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

1 Solution

Accepted Solutions

Re: Limiting records displayed in a straight table

Use set analysis in your expressions:

{<ActionFlag = {000}>}

View solution in original post

6 Replies

Re: Limiting records displayed in a straight table

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.

chitemerere
Valued Contributor

Re: Limiting records displayed in a straight table

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

ActionFlag = 000

and this does not work

Re: Limiting records displayed in a straight table

Use set analysis in your expressions:

{<ActionFlag = {000}>}

View solution in original post

MVP & Luminary
MVP & Luminary

Re: Limiting records displayed in a straight table

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.

chitemerere
Valued Contributor

Re: Limiting records displayed in a straight table

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

chitemerere
Valued Contributor

Re: Limiting records displayed in a straight table

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