topic Formula for exclusion characteristics in QlikView

Formula for exclusion characteristics

rassanbekov — Mon, 29 May 2017 05:28:53 GMT

Hello!

Could you please advice how to exclude characteristic from expression?

For example

Calculation

As a result, I need to multiple Header 2 with Header 3, and in calculation need to exclude the characteristic 3

Waiting you comments,

Thanks!

qlikview979 — Mon, 29 May 2017 05:45:46 GMT

Not understand,

Please share the sample output

Anil_Babu_Samineni — Mon, 29 May 2017 05:52:34 GMT

Like this?

Sum({<[Header 1] -= {'Charateristic 3'}>} ([Header 2] * [Header 3]))

rassanbekov — Mon, 29 May 2017 05:52:57 GMT

I have already included example of the input data in the message.

In the formula sum(header 2 * header 3), I need to exclude from calculation "Characteristic 3" or "20 and 40" respectively.