topic Re: Set Analysis - Ignore a selection in QlikView

Set Analysis - Ignore a selection

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

Hi,

Would like to create a set analysis that would ignore a selection, but this won't work. Any idea what the problem is?

If(Fruits = 'Red',

Sum({$< Fruits = {'Red'}, Apple >}Sweet),

Sum({$< Fruits = {'Green'}, Apple >}Sweet)

)

I'd like to ignore the field of Apple.

Re: Set Analysis - Ignore a selection

Chanty4u — Mon, 21 May 2018 09:02:03 GMT

try

Sum({$< Fruits= {'Red','Green'}, Fruits-={'Apple'} >}Sweet)

If(Fruits = 'Red',

Sum({$< Fruits= {'Red','Green'}, Fruits-={'Apple'} >}Sweet)

)

Re: Set Analysis - Ignore a selection

chinnuchinni — Mon, 21 May 2018 09:04:33 GMT

hi,

you can exclude the apple like this below:

sum({<fruit_color = {'Red'},fruit_type -= {'Apple'}>}sweet)

Re: Set Analysis - Ignore a selection

Anil_Babu_Samineni — Mon, 21 May 2018 09:10:09 GMT

You can't define same fields 2 times within Set expression.

Anyway, arwinpabz can you describe exactly what you are doing? You want to exclude the value or field ignore?

Re: Set Analysis - Ignore a selection

Chanty4u — Mon, 21 May 2018 09:12:38 GMT

yes i missed it it might be other field but he didnt mentioned so i thought he will change

Excluding values in Set Analysis

Re: Set Analysis - Ignore a selection

Anonymous — Mon, 21 May 2018 09:54:27 GMT

This is my real code.. I'd like to ignore the selection of months. But it's not working.

If(vCurrency_1 = 'CND',

Sum({$< Currency = {'CND'}, Month>}Budget),

Sum({$< Currency = {'USD'}, Month>}Budget)

)

Re: Set Analysis - Ignore a selection

sudhirpkuwar — Mon, 21 May 2018 09:56:57 GMT

Try this

If(vCurrency_1 = 'CND',

Sum({$< Currency = {'CND'}, Month=>}Budget),

Sum({$< Currency = {'USD'}, Month=>}Budget)

)

Re: Set Analysis - Ignore a selection

Anonymous — Mon, 21 May 2018 10:11:14 GMT

Already did that but it not working as well..

Re: Set Analysis - Ignore a selection

tresB — Mon, 21 May 2018 10:13:21 GMT

Could you share your app with sample data?

Re: Set Analysis - Ignore a selection

keerthika — Mon, 21 May 2018 10:13:57 GMT

Hi,

Can you share your app

Re: Set Analysis - Ignore a selection

Anonymous — Mon, 21 May 2018 10:34:57 GMT

Can't share the app as it contains confidential data.. Is there any form of set analysis that would give me the same result?

Re: Set Analysis - Ignore a selection

big_dreams — Mon, 21 May 2018 10:40:16 GMT

Apple is fieldName or value in table?

If it is value then it come under which field ?

If you want to show sum of sweet where Fruit is Red or Green.

then just use

sum({<Fruits={'Red','Green'}>}Sweet)

Regards,

Re: Set Analysis - Ignore a selection

tresB — Mon, 21 May 2018 10:41:54 GMT

Check this: Preparing examples for Upload - Reduction and Data Scrambling

Re: Set Analysis - Ignore a selection

vijetas42 — Mon, 21 May 2018 10:46:38 GMT

First check value of your variable vCurrency_1 that, are you getting selected value (CND or USD) in it?

If(vCurrency_1 = 'CND',

Sum({<Currency = {'CND'},Month>}Budget),

Sum({<Currency = {'USD'},Month>}Budget)

)

Re: Set Analysis - Ignore a selection

Anonymous — Mon, 21 May 2018 11:30:44 GMT

It's selected to CND.. All were correct but I just want to disregard the month selection..

Re: Set Analysis - Ignore a selection

sunny_talwar — Mon, 21 May 2018 11:33:52 GMT

How do you define vCurrency_1? is this an expression? Are you ignoring selection in Month field for the expression behind vCurrency_1?

Re: Set Analysis - Ignore a selection

sudhirpkuwar — Mon, 21 May 2018 11:45:55 GMT

Its working fine at my end

check this if you can find it useful

Re: Set Analysis - Ignore a selection

vijetas42 — Mon, 21 May 2018 11:50:20 GMT

Can you please provide expression that you have wrote for vCurrency_1

Re: Set Analysis - Ignore a selection

sasiparupudi1 — Mon, 21 May 2018 12:04:15 GMT

If(vCurrency_1 = 'CND',

Sum({1<Currency = {'CND'},Month>}Budget),

Sum({1<Currency = {'USD'},Month>}Budget)

)

Re: Set Analysis - Ignore a selection

Anonymous — Mon, 21 May 2018 12:13:22 GMT

Its just vCurrency_1 = CND