Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody
I got a difficult question and after trying it for a few hours... you guys are my last hope.
The Idea is simple, I want to do a selection using the result of an expression. The statement below is placed as expression in a straight table chart where the result field of the expression (Cases.CASE_NR) is also the dimension. The table is now looks like a listbox of the Field "Cases.CASE_NR" and, like in a list box, I'd like to do something like "select possible" which of course doesn't work for a table chart.
(Table has the Fields Cases.CASE_NR, Cases.STATUS_NR, Cases.VALID_FROM, Cases.VALID_TO and is part of a Data warehouse)
=only({$<Cases.CASE_NR = E({1<Cases.STATUS_NR-={22},Cases.VALID_FROM={"<=01.02.2007"},Cases.VALID_TO={">=01.01.2007"}>}),Cases.STATUS_NR={22},Cases.VALID_FROM={"<=01.02.2007"},Cases.VALID_TO={">=01.01.2007"}>}Cases.CASE_NR)
So, if you could select values of CASE_NR that would work for you?
Did you try opening up the Advanced Search window and pasting your expression in there? To open Advanced Search right-click on a listbox or multibox for the CASE_NR field. Advanced Search should be able to select values of the field based on your expression (assuming that there's no syntax errors in the expression).
So, if you could select values of CASE_NR that would work for you?
Did you try opening up the Advanced Search window and pasting your expression in there? To open Advanced Search right-click on a listbox or multibox for the CASE_NR field. Advanced Search should be able to select values of the field based on your expression (assuming that there's no syntax errors in the expression).
It's working! Just copied my monster-SET into Advanced Search and got the same result as shown in the Chart!
I guess, that's it
Thank you!