topic Re: set expression in QlikView

set expression

Anonymous — Mon, 06 Jul 2015 09:21:57 GMT

Hi,

I need a set expression which ignores the current selection in the Field 'Media' and excludes the value 'Internet'.

If I try <Media-={'Internet'}>, then it excludes Internet but takes into account all current selections.

How can I set it to ignore the current selection in the Field 'Media'?

Thank you in advance,

Larisa

Re: set expression

alexandros17 — Mon, 06 Jul 2015 09:23:37 GMT

try with

<Media-={'Internet'}, Media=>,

Re: set expression

MK_QSL — Mon, 06 Jul 2015 09:25:16 GMT

SUM({1<Media-={'Internet'}>}YourFactDataField)or

SUM({<Media={'*'}-{'Internet'}>}YourFactDataField)

Re: set expression

jagan — Mon, 06 Jul 2015 09:29:05 GMT

Hi,

Try like this

<Media=P(Media) - {'Internet'}>

Instead arrive a flag in the script for internet and use that flag, it is best approach

LOAD

If(Media='Internet', 1, 0) AS IsMediaInternet

FROM DataSource;

Now use

<IsMediaInternet={0}> for excluding internet

Hope this helps you.

Regards,

Jagan.

Re: set expression

er_mohit — Mon, 06 Jul 2015 09:35:00 GMT

Try like this

Sum({<Value-={'Internet'},Media=>}Salevalue)

Re: set expression

svenkita — Mon, 06 Jul 2015 09:48:12 GMT

The following expression will exclude the current selection and Internet

Sum({<Media=e(Media)-{'Internet'} >}Sales)

Attached is a sample file

Hope this helps

Re: set expression

jonathandienst — Mon, 06 Jul 2015 09:53:56 GMT

If you want to respect all selections except Media, but want to exclude selections in Media, then this will ignore the Media selection:

=Sum({<Media-={'Internet'}>} Sales)

If something else is selected that is limiting Media, then that something else will be restricting the metrics as well, so there is no need usually to take this into account - just let QV handle the associations for you.

However, if there is some reason you need to consider selections except for those in Media, perhaps you need a union or intersection in the set expression, something like these:

Sum({$<Media> * 1<Media-={'Internet'}>} Sales) (intersect - I think this will be the same as above

Sum({$<Media> + 1<Media-={'Internet'}>} Sales) (union - will include current selections with media ignored, as well as values with Media excluding Internet)

Re: set expression

Anonymous — Mon, 06 Jul 2015 09:54:22 GMT

Thanks, everyone!