Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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