Exclude based on certain conditions

n1ef5ng1 — Tue, 07 Oct 2014 06:14:03 GMT

Hi I have this particular code based on chart 1

Sum({<

CO_Operator_Group_Code={'MM'},Consortium = {$(var_consortium_1)},Service_Type_Indicator={$(var_2)}

>} Sales))

Based on this eqn, it tell us that MM (Container Operator : CO) has the number of sales based on certain consortium and service type indicator. Note that consortium and service type are variables.Each of these variables contains 4 fields out of 30 in total.

For chart 2 , i will like to have the total Sales - chart 1 code to give chart 2. Is there any other code that I can use to get this Sales - Chart 1 = chart 2?

I would like to avoid using this :

sum({CO_Operator_Group_Code = {'MM'}>}Sales

Sum({<

CO_Operator_Group_Code={'MM'},Consortium = {$(var_consortium_1)},Service_Type_Indicator={$(var_2)}

>} Sales))

Consortium and service type indicator work like an or function. take in the sales amount so long if the sales does not contains consortium or service, type

Re: Exclude based on certain conditions

n1ef5ng1 — Tue, 07 Oct 2014 08:47:34 GMT

Anybody have any thoughts

topic Re: Exclude based on certain conditions in QlikView

Exclude based on certain conditions

Re: Exclude based on certain conditions