topic Re: Set analysis - ignore the selection? in QlikView

Set analysis - ignore the selection?

Fri, 17 Jun 2016 15:20:23 GMT

Hi All,

Is it possible to ignore the selection in set analysis? Below does not work:

sum({$<Category = {'category1'}>}[Number of people])

Re: Set analysis - ignore the selection?

Nicole-Smith — Fri, 17 Jun 2016 15:22:47 GMT

Using 1 will ignore all selections:

sum({1<Category = {'category1'}>}[Number of people])

If you only want to ignore selections in a particular field, you would do it this way:

sum({$<Category = {'category1'}, IgnoreField =>}[Number of people])

Re: Set analysis - ignore the selection?

jolivares — Fri, 17 Jun 2016 16:00:15 GMT

OK... let's see, what you want to ignore.

Sum all Category = 'category1'

sum({$<Category = {'category1'}>}[Number of people])

Sum all Category <> 'category1'

sum({$<Category -= {'category1'}>}[Number of people])

sum({$<Category = {'*'}-{'category1'}>}[Number of people])

Ignore the selections on Category

sum({$<Category = >}[Number of people])

Re: Set analysis - ignore the selection?

sunny_talwar — Fri, 17 Jun 2016 16:07:08 GMT

What are you wanting to ignore selection in? Category or another field? If its category, it should work the way it is right now:

Sum({$<Category = {'category1'}>}[Number of people])

For another field, you can add them as a comma separated list for each field you want to ignore selection in

Sum({$<Category = {'category1'}, Field1, Field2, Field3, Field4, Field5.....>}[Number of people])

If you want to ignore selection in all fields except in few fields you can do this:

Sum({1<Category = {'category1'}, Field100 = $:: Field100, Field101 = $::Field101.....>}[Number of people])

If you want to ignore all field selecions, then this:

Sum({1<Category = {'category1'}>}[Number of people])

Re: Set analysis - ignore the selection?

Clever_Anjos — Fri, 17 Jun 2016 16:17:37 GMT

Remeber that you can ignore the selection but not the dimension, ok?

Re: Set analysis - ignore the selection?

sunny_talwar — Fri, 17 Jun 2016 16:19:46 GMT

cleveranjos‌ did not completely understand your comment. Can you provide more details?

Re: Set analysis - ignore the selection?

Clever_Anjos — Fri, 17 Jun 2016 16:32:25 GMT

It´s a commom question when someome try to create a Set Analysis expression that consider the value of the dimension.

The set analsys expression is evaluated globally before the cube is expanded (as hic‌ have taught in A Primer on Set Analysis), so if you need a expression that need to be evaluated per dimension value you need to use another technique (if´s, sum(total, etc)

Re: Set analysis - ignore the selection?

sunny_talwar — Fri, 17 Jun 2016 16:36:12 GMT

Got it That's what I thought you might mean, but just wanted to make sure

Re: Set analysis - ignore the selection?

Clever_Anjos — Fri, 17 Jun 2016 16:39:27 GMT

The most commom is something like:

SUM({<SalesDate={"$(=Date(Max(SalesDate)))"}>} Ammount) and Customer as dimension

Max(SalesDate) is evaluated once before the cube is evaluated and not for each Customer

Re: Set analysis - ignore the selection?

Clever_Anjos — Fri, 17 Jun 2016 16:40:40 GMT

As we were writing about ignoring selections

sum({$<Category = >}[Number of people]) will not ignore the dimension Category (if it is in the dimension list)

Re: Set analysis - ignore the selection?

sunny_talwar — Fri, 17 Jun 2016 16:43:45 GMT

I believe it will. Are you sure it won't?

Re: Set analysis - ignore the selection?

Clever_Anjos — Fri, 17 Jun 2016 16:48:04 GMT

Well, using my version, that expression is respecting the dimension

Re: Set analysis - ignore the selection?

sunny_talwar — Fri, 17 Jun 2016 16:53:51 GMT

What I meant was the selection in Dim1 won't have any impact on second expression, but first expression will become 0 for excluded Dim1

Re: Set analysis - ignore the selection?

Clever_Anjos — Fri, 17 Jun 2016 16:58:15 GMT

yes, if you refering to a selection, I was writing about dimension cube evaluation., just putting my two cents to discussion

Re: Set analysis - ignore the selection?

sunny_talwar — Fri, 17 Jun 2016 16:59:11 GMT

That make sense, but the word 'selection' confused me

Re: Set analysis - ignore the selection?

Anonymous — Mon, 19 Feb 2018 17:45:07 GMT

Hi All,

I have a similar issue.

I have a textbox:

=Num(SUM({1<[Lager]={"<>SP"},[Datum]={"=Datum >= Today()-Tagezurueck"}>}MengeABS),'# ##0')&' STK'

I want that textbox to ignore all other selections.

Re: Set analysis - ignore the selection?

Iraa — Thu, 21 May 2020 19:57:01 GMT

Hi I have similar situation but still I am struggling to understand this expression.. I have text box using variable : 'vOrder_Volume' , I have multiple filters in my dashboard Like Country, zone ,branch,Code etc. But I want to keep only Branch and below level selection and ignore all above level (Zone, Country) selection , How to make set analysis ? I am trying same as above expression but as I have variable,So Its not working. Can anyone please help me with that?

Thanks

Re: Set analysis - ignore the selection?

Dan36 — Mon, 18 Dec 2023 03:25:36 GMT

Always try to remind myself how to do this and the responses always reference ignoring specific selections.

Someone correct me if I am wrong but if you want to ignore all selections and just return a value then simply do this:

Sum({1}[Field])

Count({1}[Field])

Count(distinct {1}[Field])

etc.