topic filter out / omit rows from straight table in QlikView

filter out / omit rows from straight table

ilanbaruch — Mon, 22 Oct 2018 13:49:43 GMT

hi all

i want to filter out some rows from a straight table based on a calculation or one of the expressions in the table.

i.e rows that are less then 50 in the 'Amount' expression

any ideas

advanced thanks

Re: filter out / omit rows from straight table - NPrinting

Ruggero_Piccoli — Mon, 22 Oct 2018 14:06:34 GMT

Hi,

add the filter in the original straight table.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: filter out / omit rows from straight table - NPrinting

Lech_Miszkiewicz — Mon, 22 Oct 2018 22:31:31 GMT

Agree with Ruggero,

You can use set analysis for this purpose or dimension limits. On this note..: I would avoid using calculated dimensions as they might not work as expected in some NPrinting scenarios (for example, when table is used as a level).

cheers

Lech