Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

"Reverse" filter list box

Hi all,

I need to filter out values using a classic filter box from a report.

Here you are an example:

Capture2.PNG

If I filter for "A" , I don't want to shows rows associated to A (like as default), but I need to exclude them from the linear table.

Thanks in advance

1 Solution

Accepted Solutions
NareshGuntur
Partner - Specialist
Partner - Specialist

Try using the expression

Sum({<ITEMS=e(ITEMS)>}PRICE)

View solution in original post

3 Replies
marcus_sommer

Try: sum({< Items = e(Items)>} Price) as expression in your object(s).

- Marcus

NareshGuntur
Partner - Specialist
Partner - Specialist

Try using the expression

Sum({<ITEMS=e(ITEMS)>}PRICE)

Not applicable
Author

Wow! Thank you very much