filter out / omit rows from straight table - Qlik Community

ilanbaruch · ‎2018-10-22

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

Ruggero_Piccoli · ‎2018-10-22

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.

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

Lech_Miszkiewicz · ‎2018-10-22

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.