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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
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