Set_expression blocks regular user_selection in spite of $?
Hi,
I have a chart with the date as dimension and a COUNT(DISTINCT) as expression.
=> The tricky thing is, I need to display two values and a quota out of these two
- One of those values is available every day (so it is there for today)
- The other is available only up to yesterday
=> That would give me a quota of 100% for "today" which is false.
=> To avoid that, I have to block the display for "today"
=> To that end, I have a set_expression in my formula that looks something like this
>>> {$<%Date < TODAY>} <<<
<=> That set_expression works fine - but, what I didn't realize until now just because I never tested it - is that it seems to block regular user_selections on that same date_field >> %Date << - when I select only one day on that field, the expression where I have that set_expression does not react, only the other one where I don't have it - which is again wrong 😉
it works now all right - I just find it very confusing that the expression_editor underlines nearly the entire expression - and says "Expression OK" at the same time 😉
I think that has already been entered as an "idea" at least once. Do you think that the editor is ever going to be up to all the functions QlikView can perform?
