Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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.
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
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!
Glad to be of help, Karen.
I agree this forum is absolutely great when developing!