topic Re: Set Analysis - OR in QlikView

Set Analysis - OR

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have value field called 'Sales' and two category fields, for example 'CategoryA' and 'CategoryB'.

I want to include the expression sum(Sales) but only where CategoryA OR CategoryB equal "ProductA"

What would the set analysis be?

Thanks

Re: Set Analysis - OR

sunny_talwar — Mon, 16 May 2016 10:26:33 GMT

Try this:

Sum({<Category = {'CategoryA', 'CategoryB'}>}Sales)

Re: Set Analysis - OR

ankit777 — Mon, 16 May 2016 10:27:12 GMT

try like this

if (CategoryA ='ProductA' or CategoryB='ProductA', sum(Sales))

Re: Set Analysis - OR

Chanty4u — Mon, 16 May 2016 10:28:31 GMT

Try this

=sum({<Catageory={'CategoryA ',' CategoryB'}>}sales)

Re: Set Analysis - OR

Anonymous — Mon, 16 May 2016 10:28:34 GMT

The fields are CategoryA and CategoryB and I want to include when the value in either CategoryA or CategoryB is ProductA

Re: Set Analysis - OR

Anonymous — Mon, 16 May 2016 10:29:49 GMT

I'd rather not use if statements

Re: Set Analysis - OR

sunny_talwar — Mon, 16 May 2016 10:30:10 GMT

May be this:

Sum({<CategoryA = {'ProductA'}> + <CategoryB = {'ProductA'}>}Sales)

Re: Set Analysis - OR

Chanty4u — Mon, 16 May 2016 10:31:58 GMT

try

sum({<CategoryA='ProductA' or CategoryB='ProdcutA' >}sales)

Re: Set Analysis - OR

Anonymous — Mon, 16 May 2016 10:32:32 GMT

Try

Sum({<CategoryA = {'ProductA'}>}Sales)+Sum({<CategoryB = {'ProductA'}>}Sales)

Re: Set Analysis - OR

Anonymous — Mon, 16 May 2016 10:35:41 GMT

Sum({<CategoryA ={'Product A'} > + <CategoryB={'Product A'}>}Sales)

Re: Set Analysis - OR

trdandamudi — Mon, 16 May 2016 10:37:48 GMT

May be as below:

Sum({$<CategoryA={'ProductA'}> + <CategoryB={'ProductA'}>} Sales)

Re: Set Analysis - OR

Anonymous — Mon, 16 May 2016 10:40:27 GMT

This looks good, however I want to include other set analysis criteria. Here is the actual expression I am using, but it's telling me there is an error

sum({<[XL Date]={"<=$(vLatestReturnsDate)"},[Ledger Type]={"Actual"},[Commission Of]={"Salads"}+[Trading Of]={"Salads"}>}[Hds/Kg KPI])

Re: Set Analysis - OR

ankit777 — Mon, 16 May 2016 10:40:46 GMT

it would be then

sum({<CategoryA ={'ProductA'}>+< CategoryB={'ProductA'}>} sum(Sales))

Re: Set Analysis - OR

ankit777 — Mon, 16 May 2016 10:43:28 GMT

Try this

sum({<[XL Date]={"<=$(vLatestReturnsDate)"},[Ledger Type]={"Actual"},[Commission Of]={"Salads"}>+

<[XL Date]={"<=$(vLatestReturnsDate)"},[Ledger Type]={"Actual"},[Trading Of]={"Salads"}>}[Hds/Kg KPI])

Re: Set Analysis - OR

Kushal_Chawda — Mon, 16 May 2016 10:44:28 GMT

=Sum({<CategoryA={'ProductA'},CategoryB={'ProductA'}>}Sales)

Re: Set Analysis - OR

Anonymous — Mon, 16 May 2016 10:45:42 GMT

Replace the +[Trading Of]={"Salads"} with ,[Trading Of]={"Salads"}

Re: Set Analysis - OR

sunny_talwar — Mon, 16 May 2016 10:45:44 GMT

Try this:

Sum({<[XL Date] = {"<=$(vLatestReturnsDate)"}, [Ledger Type]={"Actual"}, [Commission Of]={'Salads'}> +

<[XL Date] = {"<=$(vLatestReturnsDate)"}, [Ledger Type]={"Actual"}, [Trading Of]={'Salads'}>}[Hds/Kg KPI])