Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
SUM({1<Media-={'Internet'}>}YourFactDataField)or
or
SUM({<Media={'*'}-{'Internet'}>}YourFactDataField)
try with
<Media-={'Internet'}, Media=>,
SUM({1<Media-={'Internet'}>}YourFactDataField)or
or
SUM({<Media={'*'}-{'Internet'}>}YourFactDataField)
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.
Try like this
Sum({<Value-={'Internet'},Media=>}Salevalue)
The following expression will exclude the current selection and Internet
Sum({<Media=e(Media)-{'Internet'} >}Sales)
Attached is a sample file
Hope this helps
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)
Thanks, everyone!