topic Re: Why do my points disappear? Set Analysis {1}? in QlikView

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

Wed, 25 Nov 2020 16:16:04 GMT

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

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

RonaldDoes — Wed, 07 Jun 2017 13:20:47 GMT

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.

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

zebhashmi — Wed, 07 Jun 2017 13:39:10 GMT

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.

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

vinieme12 — Wed, 07 Jun 2017 13:39:57 GMT

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

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

Thu, 08 Jun 2017 08:14:38 GMT

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!

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

RonaldDoes — Thu, 08 Jun 2017 08:18:10 GMT

Glad to be of help, Karen.

I agree this forum is absolutely great when developing!