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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

field values

Hi,

     i have feild which contains the name of the plant. In that i want to remove 2 values and the same time i want to use that expresion in set to remove the count.

plant

A

B

C

D

SUM

100

200

300

400

I want to remove B and C along with sum in an expression. In that expression i am already using set analysis

Regards,

rasool

1 Reply
swuehl
MVP
MVP

Would be easier if you post your current dimension and expression(s) used.

You can start with something like dimension plant and expression

=Sum({<plant -= {B,C}>} SUM)