This is a more general question about set analysis modifier behaviour. I've always believed that string modifiers in a set analysis have to be within ...
Show More
This is a more general question about set analysis modifier behaviour. I've always believed that string modifiers in a set analysis have to be within quotes, like this
Sum({<Color={'Green'}>}Amount)
and for modifiers with numeric value the quotes where optional like this
Sum({<ColorID={1}>}Amount) OR Sum({<ColorID={'1'}>}Amount)
But I noticed that the two expressions below returns the same result.
Sum({<Color={'Green'}>}Amount) AND
Sum({<Color={Green} >}Amount)
Is this an correct observation? Is this new or old behaviour? I notice that the examples in the Qlik help page Set analysis and set expressions are ambivalent in the use of ' ' or not ' '.
Does anyone have a link to Qlik Help och Qlik Support that describes the use of quotes in modifers? I assume that QlikView/Qlik Sense intepret the two differently hence:
Sum({<Color={'*'}>}Amount) is not equal to Sum({<Color={*}>}Amount)
Data sample from the attached qvw file:
DATA:
LOAD * INLINE [
ColorID, Color, Amount
1, Green, 100
2, Red, 200
3, Yellow,300
0, *, 400
];
Do you @BrettBleess or @rwunderlich know anything about this set modifier behaviour/intepretion?
Show Less
Community
