topic Re: Ignore selections Set Analysis in QlikView

Ignore selections Set Analysis

Anonymous — Thu, 05 Dec 2013 15:22:08 GMT

Hello, I need to ignore selections in all fields except those included in the expression below. How can I do that?

Sum ({$<År = {$(=max(År))}, Kvartal = {$(=maxstring(Kvartal))}, Mottagare = {$(=maxstring(Mottagare))}, Version = {'$(vVersion1)'} >} Vattenfall_Value)

Sum ({$<År = {$(=max(År))}, Kvartal = {$(=maxstring(Kvartal))}, Mottagare = {$(=maxstring(Mottagare))}, Version = {'$(vVersion2)'} >} Vattenfall_Value)

Re: Ignore selections Set Analysis

Thu, 05 Dec 2013 15:25:59 GMT

Hi,

Use 1 instead of the first $

sum({ 1 < ......

1 signifies ALL, $ signifies the current selections

Fabrice

Re: Ignore selections Set Analysis

hic — Thu, 05 Dec 2013 15:26:48 GMT

If you want to ignore all selections, you should use "1" instead of "$". E.g. ... {1<År= ...

HIC

Re: Ignore selections Set Analysis

pgrenier — Thu, 05 Dec 2013 15:42:07 GMT

Hello Johan,

In order to ignore all selections except a distinct few, you may use the following approach:

Sum({1<Year=$::Year>} Sales)

So, for your specific expression, it would look something like:

Sum({$<Âr=$::Âr, Kvartal=$::Kvartal, Mottagare=$::Mottagare, Version= {'$(vVersion1)'} >} Vattenfall_Value)

Cheers,

Philippe