topic How to write the following expression correctly ? in QlikView

How to write the following expression correctly ?

suvechha_b — Mon, 21 Dec 2015 09:19:39 GMT

How to write the expression correctly,

Eg,

I have three option in category_ of_sales : Processed, Unprocessed, Unspecified.

But, My requirement is I need to show only 'Unprocessed' and 'Unspecified' reports for a specific tab.

I tried this , but giving error.

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales<>'Processed'>} Amount)

Mon, 21 Dec 2015 09:23:01 GMT

Try:

sum({$<TranType = {'$(vAmountType)'},[Fiscal_Year]=,[Month]=,category_of_sales-={'Processed'}>} Amount)

sasikanth — Mon, 21 Dec 2015 09:23:43 GMT

Try this

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales={'*'}-{'Processed'}>} Amount)

Mark_Little — Mon, 21 Dec 2015 09:23:52 GMT

Try

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales-={'Processed'}>} Amount)

Mark

Mon, 21 Dec 2015 09:24:34 GMT

try this

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales-={'Processed'}>} Amount)

effinty2112 — Mon, 21 Dec 2015 09:30:42 GMT

Try:

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales-={'Processed'}>} Amount)

which will respect selections of 'Unprocessed' or 'Unspecified' in the category_of_sales field

Or:

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales=-{'Processed'}>} Amount)

which is similar except that selections in the category_of_sales field will not be respected.

category_of_sales=-{'Processed'}

is the same as

category_of_sales={*} - {'Processed'} ie. ALL except 'Processed'.

Cheers