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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
1 Reply
swuehl
Champion III
Champion III

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)