Table functions

Wed, 12 Jan 2011 11:20:39 GMT

Hi,

I have a question about the use of the only function.
I made the following expression:

Only ({<Startdatum_AO ={'>=$(Vanaf)<=$(Tot)'}> +
<Einddatum_AO={'>$(Vanaf)<=$(Tot)'}> +
<Startdatum_AO={'<=$(Vanaf)'}, Einddatum_AO={'>=$(Tot)'}>
}
if(Startdatum_AO < Vanaf, Vanaf, Startdatum_AO))

It shows the correct information but when a record is 2 times in the database it only shows 1 of the records.
We expect that's because the ONLY function.

Does anybody know how the get both records out of the database?

topic Table functions in QlikView

Table functions