Why do my points disappear? Set Analysis {1}?

[#1]

Hi folks,

Can someone have a look at the attached file and tell me why my Machine Result points disappear when I select machine number 2?

I thought I overrode the selections in the set analysis by choosing {1}, not {$}? So shouldn't it always show machine 1 results, regardless of my selection?

Any help greatly appreciated

Karen

[RonaldDoes · Accepted solution]

Hi Karen,

It's in your * in Machine result set analysis:

Avg 
({1
<Machine={'1'}> * <Date = {"$(='>=' & Min([Cal Date]) & '<=' & Max([Cal Date]))"}>
}
Result)

Replace that with:

Avg
({1
<Machine={'1'}, Date = {"$(='>=' & Min([Cal Date]) & '<=' & Max([Cal Date]))"}>
}
Result)

And you're good to go.

Why? Because of intersections. You essentially give two sets, and tell QlikView to only use intersecting sets.

[zebhashmi]

Hi - i am trying to answer you without looking in to your file i can't open it here.

{1} should show Value without feather filtration so its good for KPI's

but if you are using within Chart, other selections may change the values.

unless you set the calculation method in properties.

[vinieme12]

Hi Karen,

We use * or + when we want to combine two sets of conditions

example1

Where (  condition1 and  condition2  and condition3 )

AND

         (  condition3 and  condition4  and condition4 )          

in the above example the conditions 1 to 3 represent 1 SET of conditions and the capital AND in between those conditions is represented by '*' in set analysis and would be written as below with the and's inside the set being replaced by comma's

{<condition1 , condition2  , condition3> * <condition3 ,condition4  , condition4>}

similary for OR operator that is '+' in Set Analysis

hope this makes sense.

References below

Set Analysis: syntaxes, examples

Set analysis and set expressions ‒ QlikView

[#5]

Wow - my understanding of set analysis syntax was fundamentally wrong this whole time!

I've only worked with the current selection {$} up to now and therefore my "wrong" syntax has amounted to the same thing.

Thank you all - particularly vinieme12 ronalddoes for explaining it clearly.  This forum is incredibly useful!

[RonaldDoes]

Glad to be of help, Karen.

I agree this forum is absolutely great when developing!