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)
The only thing I came up with so far is to write a macro that runs through the whole chart and selects each and every single CASE_NR with a do - loop.
A few things you need to know:
The expression has to be done with SET because it's not possible otherwise (I'm using indirect SET) and I also cant flag the records because the date which is now a specific one is going to be replaced by variables (so is the Cases.STATUS_NR).
The number of records in the table that qualifies for selection will be up to 1.5 millions, so it's an performance issue too. (The whole Table "Cases" has more than 35 million records)
If there is an "QlikView way" to use the result of an expression to select data, then I'm sure that I'll get it here or nowhere!
Kind regards and thanks in advance!
